Once you put the formula in, it overwrites whatever was there. If you just
want the cell to appear blank, then you would put in """" for the false
condition. If you mean the cell already contains something which you want
to retain, then you can't do that unless for each cell in the range, you
build the formula individually for each cell, putting the current value as
the False result.

--
Regards,
Tom Ogilvy


"hotherps " wrote in message
...
Hi I'm using the following formula in a routine:

Range("G11:CX298").Formula = "=IF(AND($DX11<$B11,$G11="".""),$DZ11)"


If the criteria = true then it placecs the value of $DZ11 which is want
I want.

What do I put in for the false part of the statement if I want to take
no action? I don't want to clear or change the contents at all if the
condition is false.

Thanks


---
Message posted from http://www.ExcelForum.com/