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

Check if a cell contains text
 

One way:

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

In article ,
"GreenMonster" wrote:

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.