Possible? formula in one cell can fill another cell
 

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

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

If so, what is the syntax? Thanks!

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(A10,"Yes","")

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Sherri" wrote in message
...
Is it possible to have a formula in one cell fill a different cell?

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

If so, what is the syntax? Thanks!

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(A10, [C1="yes"], [do nothing])

If so, what is the syntax? Thanks!
.

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


"Jason Morin" wrote:

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(A10, [C1="yes"], [do nothing])

If so, what is the syntax? Thanks!
.