Something like this in say B1?

=IF(A110,H1,"")

which tests cell A1, and if the value is greater than 10, stores the
contents of H1 in cell B1, otherwise it stores an empty string.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mr. Clean" wrote in message
...
I need a formula in one cell that, under certain conditions (and IF
statement), writes the value of one cell into another cell. In this case,
I
can't use a macro. Anyone done this sort of thing before?