Support Board
Date/Time: Tue, 13 May 2025 11:03:40 +0000
Post From: Spurious TRUEs in the New Spreadsheets version
| [2015-05-06 05:22:08] |
| Sawtooth - Posts: 4214 |
|
I am experiencing occasional spurious TRUEs in some cells where the formula clearly should produce FALSE. I can clear the bogus TRUE by entering that particular cell's edit mode, then clicking OK. I cannot clear the cell by Reload and Recalculate, nor Recalculate, nor unchecking/checking Auto-Calculate. It appears there is no recalc unless the edit mode is entered. The example cell is in row 96. This is the formula in that cell: =AC96>=MAX(AC97:INDIRECT("AC"+TEXT(ROW()+$H$15,"0"))) Please advise. |