Hello,
Can I change e.g. A1 cell value, according to the value of B1 cell when B1 value depends on A1 value?
For example, if A1 value is 2, B1 value is 2*A1 and if B1 value is bigger than 3 then automatically A1 value to be changed to 3.
Best wishes
Hello
In general the answer is “No” - you would get error #522 -Circular reference since formula would refer directly or indirectly to itself.
Note: There are scenarios where circular references may work (e.g. convergent numerical problems).
Then is it possible to do that if B1 value doesn’t depend on A1 value?
For example, if B1 value is bigger than 3 then write 1 to A1.
Of course. That’s just a simple formula in A1: =IF(B1>3;1;0) The 0 is the else (not B1>3) value, you can put any expression you want there.
Maybe my example was too easy, but in general, I am wondering whether you can overwrite/interact cell value with formula in a different cell. If we are talking about the upper example A1’s content should be number only, not a formula.
I am wondering whether you can overwrite/interact cell value with formula in a different cell.
No - that’s not possible. A formula evaluates in the current cell (i.e. the cell containing the formula) and never can overwrite another cells data.