If you select the item to evaluate in the formula bar, then hit F9, it will
show you what the selected item evaluates to. HOWEVER, you MUST remember to
hit the Esc key to clear the evaluation or the text from the evaluation will
replace the selected item and destroy your formula.

The problem in your formula is the test of a column ($B:$B for example)
against a specific constant... a column has no value to test. If you tell us
exactly are you trying to do, maybe some one here will be able to give you a
solution (provide as much detail as is necessary to understand what you have
and are doing with it). My guess is you will want one of the "lookup"
functions.

Rick


"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