I don't know if indirect is the proper term to use; I refer not to the function but rather to what, in my mind, I am trying to do.
Is there a way to change the value of a cell from another cell, specifically in an IF function? For example, suppose cell A2 has something like:
=IF(A1="Value", "True", (change value in B3))
So we are looking at the value of one cell (A1) from another cell (A2), but if a condition is not met we change the value in yet a third cell (B3).
Can this be done? I want to say yes, but I don't know how. Thanks in advance.
Is there a way to change the value of a cell from another cell, specifically in an IF function? For example, suppose cell A2 has something like:
=IF(A1="Value", "True", (change value in B3))
So we are looking at the value of one cell (A1) from another cell (A2), but if a condition is not met we change the value in yet a third cell (B3).
Can this be done? I want to say yes, but I don't know how. Thanks in advance.