Support Board
Date/Time: Mon, 13 Jan 2025 09:36:55 +0000
Post From: Spurious TRUEs in the New Spreadsheets version
| [2015-05-06 05:22:08] |
| Sawtooth - Posts: 4149 |
|
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. |