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.
|