Even better:

ToolsFormula AuditingEvaluate Formula

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
| 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