NOT

Examples

• =NOT(ISBLANK(A1))

  The NOT function is often used in tandem with the ISBLANK function to determine if a cell is empty or not. For example, this will return TRUE if A1 is empty and will return FALSE if A1 is not blank.

• =NOT(ISERROR(A1))

  The NOT function can also be used in combination with the ISERROR function to determine if a cell contains an error. For instance, this will return TRUE if A1 does not contain an error and will return FALSE if A1 does contain an error.

• =NOT(ISNUMBER(A1))

  The NOT function can also be used in combination with the ISNUMBER function to determine if a cell contains a number or not. For example, this will return TRUE if A1 does not contain a number and will return FALSE if A1 does contain a number.

• =IF(NOT(A1="yes"),0,1)

  The NOT function can also be used in combination with the IF function to create more complex logical tests. For example, this will return a 0 if A1 does not equal "yes" and will return a 1 if A1 does equal "yes".