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!