Forum Discussion

Copper Contributor

Nov 13, 2023

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

excel

Formulas and Functions

exceljunior

Copper Contributor

Nov 13, 2023

Thanks Joe!
This one works =(A1<>"NO CONTACT") but as I intend to click & drag the formula down, how do I show it as blank if the cell contains no text.
Many thanks

JoeUser2004

Bronze Contributor

Nov 13, 2023

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.

exceljunior
Copper Contributor
Nov 13, 2023
JoeUser2004
Thanks Joe - much appreciated!