View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GreenMonster[_2_] GreenMonster[_2_] is offline
external usenet poster
 
Posts: 10
Default Check if a cell contains text

I need to incorporate the function =ISTEXT(D5) into an existing if
statement. The existing if statement is

=IF(D5="One Panel","NA",IF(D5="Self Storing","NA","??"))

in my worksheet there will be times when cell D5 contains text and other
times when the cell contains nothing at all. When D5 contains nothing, I
need the cell recieving the if statment to also be left blank.

Make sense?

Thanks