Debugging formulae in Excel

[tino_szczvrcic]

Is there any facility in Excel (I'm using Excel2010), whereby you can look at part of a complex formula, and immediately see what value that part equates to?

Regards,
TS

 

[steve the fish]

Yes. Click on the part in question in the formula bar then press the fx button to the left of the formula bar.

 

[losamfr17]

Try F9 after highlighting the argument in the function.

 

[BarryL]

go to formulas on the ribbon, then press "Evaluate Formula" , you can step through the formula there

 

[tino_szczvrcic]

Thankyou - all very useful. Simple when you know how. BarryL's answer probably the safest option.