Formula result and displayed result are different

S

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?
 
S

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.
 
S

spindoctor

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top