If you are looking to set up a condition in a spreadsheet function in a situation where you want to include everything but one thing, you need to use the following:
"<>EXCLUDED_TERM"
Turns out the “less-than/greater-than” combo sign means “not equal to”, and it applies to text strings in addition to number strings.
I wasn’t sure what terms to search for initially, and relevant results for “is not”, and “is not equal to” were not giving me the answer I needed. Including terms such as “spreadsheet”, “Apple Numbers”, “function” and “formula” didn’t help either.
Continue reading “Spreadsheet tip: “is not” or “is not equal to””