So I have a cell with this trick in it to prevent the TODAY() function from updating every day:
Works perfectly for its purpose. However I have other cells with formulas that refer to this cell and it doesn't behave properly. I know for certain it's this cell that's causing the issue but I can't determine why it behaves this way. Furthermore, the exact same formula in different cells gives different results. I've linked a sheet as I feel it's easier to explain this way
Basically E2 has a simple formula: = IF(C1=C1,,"world")
E4 is just: = E2 (There's really nothing significant about that. It's just how it's on my original sheet)
And the following is the formula in the cells scattered all over the place: = IF(E4="","hi",0)
There seems to be an imaginary border dividing the sheet where everything on one side behaves one way and everything on the other side another way.
I've found a practical workaround on my actual sheet but this is bizarre to me and I'm trying to understand why it does this ??