This is, in my opinion, one big advantage Excel has over Google sheets is the self-referencing formulas. What I mean by that is: say in cell
A1, I'm changing the value in there
c. And according the letters,
A2 gives you an output.
Now I have a function in
=if(A1="a", A2, B1) basically acting like a store of value, and if the switch
a is pulled, then update the value in
A2, otherwise maintain the current value
This works in Excel but you get a "#REF" in Google. Does anybody have a solution around this?