Spreadsheet tip: “is not” or “is not equal to”

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.

Advertisements