Question Locked

Excel - copied formula is correct but result is not

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am copying a formula across to an adjacent cell. The formula appears to be correct but the result is the absolute value calculated in the original cell.

If I try to retype in the formula the result returned is a zero

What has gone wrong?

2 replies

by dogknees

Try checking of Calculation is set to Automatic. Look on the Formulas tab in the Calculation group.

This discussion is closed to new replies.