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
|