Maybe the reverse would be easier:

=IF(ISBLANK(A2),"",your_formula)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Woody13" wrote:

I'm trying to use a basic IF THEN statement but I need the IF function to
recognize whether there is text in a cell or if its blank. =IF(cellA2 has
text, forumla,"") In other words, if cell A2 is blank I want the cell with
the formula in it blank. If A2 has text written in it, I want the cell with
the formula to use another formula. How can I accomplish this?