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...
I can't see how to do this other than with iterative calculation or VBA.
I originally posted to turn on iterative calculation but I see you don't want to do that! Any specific reason or just nervousness?
This sort of works....
G25 is where I want my preserved calculation
F25 is set to Y to calculate, otherwise it won't
In G25 put
=LET(zz, INDIRECT("G25"), IF(F25="Y",10/5,zz))
You still get the error pop-up if you set F25 to N but it preserves the calculation anyway
G25 is where I want my preserved calculation
F25 is set to Y to calculate, otherwise it won't
In G25 put
=LET(zz, INDIRECT("G25"), IF(F25="Y",10/5,zz))
You still get the error pop-up if you set F25 to N but it preserves the calculation anyway