Support Board

Date/Time: Sat, 18 May 2024 16:33:36 +0000

Post From: Cells K3,L3,M3,N3 True Ignored

[2019-11-02 18:37:48] Link To Thread - Link To Post [Go To First Post]
CMG - Posts: 179
2. I do in the following case, please advise of any alternatives: I have a spreadsheet formula that references itself creating a circular reference and since new spreadsheets do not provide iterations the formula returns a #VALUE! error. However, if I manually select Spreadsheet>Recalculate all Formulas, the formula returns the correct calculation until ONLY ONE SPECIFIC variable in the formula is changed. Curiously, the formula only has to be "recalculated" when a variable in an IF statement within the formula returns a False result. 3. Are Array Formulas no longer supported by new spreadsheets? Thanks