Forumla to recognize text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forumla Needed: Text or Number Format 4
Forumla rows and columns 3
Formula shows in cell instead of results (text reference) 4
how do i copy the actual text of a formula? 7
Combining Text From Cells 3
Finding Text within an Array 2
Forumlas Aren't Auto Recalculating 1
create a formula by using text from other cells 1

Back
Top