Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Use the NOT function, one of the logical functions, to reverse the logic of its argument.Description
The NOT function reverses the logic of its argument. If the argument is TRUE, NOT returns FALSE. If the argument is FALSE, NOT returns TRUE.
One common use for the NOT function is to expand the usefulness of other functions that perform logical tests. For example, the IF function performs a logical test and then returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE. By using the NOT function as the logical_test argument of the IF function, you can test many different conditions instead of just one.
Syntax
NOT(logical)
The NOT function syntax has the following argument:
- logical - Required. The value or expression that you want to reverse, which can be either TRUE or FALSE.
Remarks
- The argument must evaluate to a logical value such as TRUE or FALSE, or in an array or reference that contains logical values.
- If the argument is an array or reference, only logical values in that array or reference are used. Empty cells, text, or numbers in the array or reference are ignored.
- If the specified range contains no logical values, NOT returns the #VALUE! error value.
Examples
| Formula | Description |
| =NOT(A2>1) | Reverses the value of the logical expression A2>1. If A2 contains 2, the expression evaluates to TRUE, and NOT returns FALSE. If A2 contains 0, the expression evaluates to FALSE, and NOT returns TRUE. |
| =NOT(A2==1) | Reverses the value of the logical expression A2==1. If A2 contains 1, the expression evaluates to TRUE, and NOT returns FALSE. If A2 contains 0, the expression evaluates to FALSE, and NOT returns TRUE. |
Errors
For a full list of formula errors, please read Formula errors.