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.