Possible? formula in one cell can fill another cell

[Sherri]

Is it possible to have a formula in one cell fill a different cell?

EX: A1: 1
B1: =IF(A1>0, [C1="yes"], [do nothing])

If so, what is the syntax? Thanks!

 

[Ken Wright]

No, a formula can only PULL data into a cell, not PUSH data. The formula
must be situated in the cell that the data is to appear in, though you can
have any number of other cells influence what appears in that cell as long
as they are referenced directly/indirectly by the formula within it.

In C1 =IF(A1>0,"Yes","")

 

[Jason Morin]

Sorry, formulas can only return values to the cells in
which they reside. You'll need a formula in C1 or use VBA.

HTH
Jason
Atlanta, GA

 

[Sherri]

I was afraid that was the case. Anyone know how to do it in VBA?

Sorry, formulas can only return values to the cells in
which they reside. You'll need a formula in C1 or use VBA.

HTH
Jason
Atlanta, GA

-----Original Message-----
Is it possible to have a formula in one cell fill a different cell?

EX: A1: 1
B1: =IF(A1>0, [C1="yes"], [do nothing])

If so, what is the syntax? Thanks!
.