Forum Discussion
IFS statement
Hi there, I'm trying to figure out a formula that will return a TRUE or FALSE value based on the below: - If the cell has the following text: NO CONTACT returns TRUE, but if it contains any oth...
exceljunior wrote: ``how do I show it as blank if the cell contains no text``
Ah, then you need an IF expression, to wit:
=IF(A1="", "", A1<>"no contact")
Aside.... There is no need to write "NO CONTACT" instead of "no contact", if you do not care about upper and lower case.
Thanks Joe - much appreciated! 