software

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,quot;quot;) 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),quot;quot;,your_formula)

Does that help?

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

XL2002, WinXP-Proquot;Woody13quot; wrote:

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

Try something like:
=IF(A2=quot;quot;,quot;quot;,IF(ISTEXT(A2),lt;your formulagt;,quot;quot;))
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Woody13quot; gt; wrote in message
...
gt; I'm trying to use a basic IF THEN statement but I need the IF function to
gt; recognize whether there is text in a cell or if its blank. =IF(cellA2 has
gt; text, forumla,quot;quot;) In other words, if cell A2 is blank I want the cell
with
gt; the formula in it blank. If A2 has text written in it, I want the cell
with
gt; the formula to use another formula. How can I accomplish this?