View Values Formula is using?
In Excel 2003, you can use the formula evaluator. Select the cell with the
formula. Then Tools/Formula/Auditing/Evaluate Formula. It's not perfect but
it does help.
In Excel 2007 select the cell with the formula then Formulas/Formula
Auditing/Evaluate Formula
Tyro
"Richhall" wrote in message
...
Hi
I have a formula:
=SUM(IF('Jan 08'!$B:$B="Day",IF('Jan 08'!$E:$E=A3,'Jan 08'!F:F,0),0))
and this is returning me a value of 0 when it should be 2. Is there a
way I can see step by step what Excel is calculating for each part of
my statement to see what it is doing?
Cheers
Rich
|