G4 is =C4+D4+E4 , what each one value is?

D

Dan

there is some way to evaluate the component of a formula by clicking f9 or
something.
Not by using the formula editing button.
I just cannot remember what it is.

I would need to know what C4 D4 and E4 values are by clicking on G4

Any idea?
Many thanks
 
N

Niek Otten

Even better:

Tools>Formula Auditing>Evaluate Formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Ok I found it - just need to highlight the portion of the formula and do an F9
|
| "Dan" wrote:
|
| > there is some way to evaluate the component of a formula by clicking f9 or
| > something.
| > Not by using the formula editing button.
| > I just cannot remember what it is.
| >
| > I would need to know what C4 D4 and E4 values are by clicking on G4
| >
| > Any idea?
| > Many thanks
 
Top