I’m having a problem where cells do not automatically update, or even MANUALLY update using options like Recalculate or Recalculate Hard. BUT they will update if I drag the formula down from the cell above–even though the formula before and after is identical.
This formula looks at a column of quarterly data and basically checks a few things like “Do these cells contain numbers? Is it dealing with a number of days over 365?” and then either returns a number or just leaves things blank.
=IF(ISNUMBER(F39),IF(AND(B39>365,ISNUMBER(F35)),F39-F35,IF(B39<365,F39,{})),{})
But when I add new numeric data to cell F39, it just doesn’t care and remains blank. Until I fill the cell again with the exact same formula by dragging from above. AutoCalculate is on, and as stated earlier Recalculate and Recalculate Hard don’t make a change. Editing the formula and hitting Enter also doesn’t change anything. Once it has actually updated, though, if I change the value of cell F39 again the result does change, so it is apparently willing to autocalculate sometimes.
When I started writing this message I was using version 25.2.something. I decided to try the obvious and have just upgraded to 26.2.0.3, but the behavior is the same.