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?

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?

Try something like:
=IF(A2="","",IF(ISTEXT(A2),<your formula,""))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Woody13" wrote in message
...
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?