Excel Error: "The cell currently being evaluated contains a constant"

[BeckyW]

My Excel formula is currently =Division!B81 Display value is 0 (zero) which is correct.

When I changed the formula to =Division!C88 the cell displays the formula rather than the value.

The Evaluate Formula explanation is "The cell currently being evaluated contains a constant". How can I fix this so the correct value displays?

Automatic calculation is on, format is set to General.

Thanks, Becky

 

[Momentman]

Check the formula again. You probably have an apostrophe starting the cell i.e '=Division!C88 as opposed to just =Division!C88