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