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!
.
|