Support Board
Date/Time: Tue, 04 Mar 2025 21:39:23 +0000
Post From: Spreadsheet CELL not updating as expected + steps to reproduce.
| [2021-12-23 18:59:34] |
| Jeffrey - Posts: 2220 |
|
Broken:
example B 1) put formula on DM18 =IF(TRUE,"DEAD",FALSE) 2) put formula on BS30 =IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes "CHEESE" 4) clear cell DM18 , cell BS30 WRONGLY STAYS "CHEESE" and does not switch to BANANAS like with example A) I assume because VLOOKUP returns #N/A an error BUT example C below works I tried repeating this on a chart and spreadsheet with nothing else going on, but when I tested it, cell BS30 correctly updates to BANANAS after clearing cell DM18. There must be some other factor involved. Try using the Details button (in the upper-right corner of the spreadsheet window) with cell BS30 selected to see if any part of the formula evaluation appears incorrect there. |