Forum Discussion
Idea needed to stop cell from calculating to preserve its value
The formula F5 = IF(F4,F5,F6) generates a circular reference when F4 = TRUE. That is a great shame because, while narrowly true, the reference to itself is harmless since the THEN for...
That is very neat!
Wondering if this could be a request to MS to add a self reference to a formula without having to turn on iterative calculations - e.g. a function called PREV() which would return the value of the current cell before the calculation. Then
=IF(F4,F5,F6)
becomes
=IF(F4,PREV(),F6)
Wondering if this could be a request to MS to add a self reference to a formula without having to turn on iterative calculations - e.g. a function called PREV() which would return the value of the current cell before the calculation. Then
=IF(F4,F5,F6)
becomes
=IF(F4,PREV(),F6)
I had thought that =IF(F4;;F6) would be perfect for the purpose. The current behaviour of this illegal/meaningless statement - it produces TRUE (when F4 is TRUE) - is not intuitive.