Formulas display 0 instead of answer

W

wicked2025

When I type in a valid formula, a 0 appears instead of the result. If I copy
a formula from a different cell, the copied formula is correct, but the
result is the same as the cell I copied from.

Some setting seems to have changed on my spreadsheet that will not calculate
formulas.
 
J

JLatham

Check
Tools | Options | [Calculate] tab and make sure that Automatic calculation
is selected?
 
W

wicked2025

It is selected.

JLatham said:
Check
Tools | Options | [Calculate] tab and make sure that Automatic calculation
is selected?

wicked2025 said:
When I type in a valid formula, a 0 appears instead of the result. If I copy
a formula from a different cell, the copied formula is correct, but the
result is the same as the cell I copied from.

Some setting seems to have changed on my spreadsheet that will not calculate
formulas.
Click to expand...
Click to expand...
 
J

JLatham

Maybe give us example of formula that is working, but when copied doesn't
work? Also with values in cells used by both of them.

wicked2025 said:
It is selected.

JLatham said:
Check
Tools | Options | [Calculate] tab and make sure that Automatic calculation
is selected?

wicked2025 said:
When I type in a valid formula, a 0 appears instead of the result. If I copy
a formula from a different cell, the copied formula is correct, but the
result is the same as the cell I copied from.

Some setting seems to have changed on my spreadsheet that will not calculate
formulas.
Click to expand...
Click to expand...
Click to expand...
 
Top