Forum Discussion
Calculation Result Error
Hello, in a very basic spreadsheet, when I a) copy a formula from one cell to the adjacent cell, the 'calculated' value is $0 or b) if I manually enter the formal into the adjacent cell, the 'calculated' value is the same as the adjacent cell. In both a) and b) scenarios the values are incorrect. Any suggestions would be appreciated.
2 Replies
On the Formulas tab of the ribbon, in the Calculation Options group, make sure that Automatic is selected in the Calculation Options drop-down.
Also, check whether the status bar at the bottom of the window mentions Circular References.
- Thanks Hans. It was a circular reference error. I learned something new. Regards, Claus
