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?

On Jul 14, 2:51*pm, spindoctor wrote:
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.

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

"spindoctor" wrote:

On Jul 14, 2:51 pm, spindoctor wrote:
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.

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

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"spindoctor" wrote:

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