Formula result and displayed result are different

[spindoctor]

When I open the Function Arguments window using the function button on
the formula bar, it says that the formula result is $1,000.00. On the
sheet, $0.00 is displayed. Why would there be a difference?
I am getting a circular reference indicator, but if that was the
problem, wouldn't I get an error message rather than $0.00?

 

[spindoctor]

When I open the Function Arguments window using the function button on
the formula bar, it says that the formula result is $1,000.00. On the
sheet, $0.00 is displayed. Why would there be a difference?
I am getting a circular reference indicator, but if that was the
problem, wouldn't I get an error message rather than $0.00?

To add a little more mystery, the cell in question which is giving the
weird result is B11. When I go to another cell and enter "=B11",
$1,000.00 appears, not $0.00.

 

[Mike H]

It sounds like a formatting issue on your formula cell but post your formula

 

[spindoctor]

=IF($A11="","",IF(VLOOKUP($A11,$A$10:$B$30,2,FALSE)=B$2,"",IF(DAY($A11)
=1,$B$2,"")))

 

[Shane Devenshire]

You say your formula is in B11 but your VLOOKUP is referencing that cell - a
bad idea at best on less you are doing integration or something similar. I
would start by removing the circular reference. Note the table range of
the VLOOKUP includes B11 with is the formula, hense the circular reference.

There may be a formatting problem but most likely it is the circular
reference.

Why exactly are you using this technique - that is, a circular reference.
Is there a specific purpose?