REMOTE CELL FUNCTION

[Guest]

Is it possible to have a formula in one cell for example if A1 had a formula,
something like =IF(B1=2,C1,""), this formula copies the value from C1 if the
value is true, is it possible to have A1 write in a formula or a value based
on the result from the IF statement from A1 into C1

A1. IS THE FORMULA B1. IS THE VALUE C1. Is equal to whatever A1 says
it is.

Thanks in advance!

Dan

 

[Guest]

No

you could put =A1 in C1

or you could write a macro to paste the value into C1, but you can not use
a formula in one cell to change what is entered in another cell without code.