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: `` If the cell has [...] NO CONTACT returns TRUE, but if it contains any other words/sentence then returns TRUE``
According to your image, you mean it should return FALSE, not TRUE, if the cell value is "NO CONTACT".
Ostensibly:
=(A1<>"NO CONTACT")
However, does the all-uppercase matter?
If so, then:
=(EXACT(A1, "NO CONTACT")=FALSE)
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
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
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!
