currentValue

currentValue returns the value of the current location.

You can use currentValue to say “do not change the value.” currentValue has a dynamic result to avoid the infinite loop that may occur if you wrote the formula directly. For example, x=if(condition, y,x) (if the condition is true, then set x to y; otherwise, leave x alone) may cause an infinite loop during dependency checking:

currentValue()