View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Woody13
 
Posts: n/a
Default Forumla to recognize text

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?