not

 The NOT function in Excel is a logical function that reverses the value of its argument. If the argument is TRUE, it returns FALSE, and if the argument is FALSE, it returns TRUE. Below are 10 examples of how to use the NOT function, including data and formulas.

Example 1: Basic Usage

Data:

• A1: TRUE

Formula:

• B1: =NOT(A1)

Result:

• B1: FALSE

Example 2: Basic Usage with FALSE

Data:

• A1: FALSE

Formula:

• B1: =NOT(A1)

Result:

• B1: TRUE

Example 3: Combining with IF

Data:

• A1: 50

Formula:

• B1: =IF(NOT(A1>100), "Below 100", "Above 100")

Result:

• B1: Below 100

Example 4: Combining with AND

Data:

• A1: TRUE

• A2: FALSE

Formula:

• B1: =NOT(AND(A1, A2))

Result:

• B1: TRUE

Example 5: Combining with OR

Data:

• A1: TRUE

• A2: FALSE

Formula:

• B1: =NOT(OR(A1, A2))

Result:

• B1: FALSE

Example 6: Using with Comparison Operators

Data:

• A1: 75

Formula:

• B1: =NOT(A1<50)

Result:

• B1: TRUE

Example 7: Nested NOT Functions

Data:

• A1: TRUE

Formula:

• B1: =NOT(NOT(A1))

Result:

• B1: TRUE

Example 8: Using with Text

Data:

• A1: "Excel"

Formula:

• B1: =NOT(A1="Word")

Result:

• B1: TRUE

Example 9: Using with Blank Cells

Data:

• A1: (Blank)

Formula:

• B1: =NOT(ISBLANK(A1))

Result:

• B1: FALSE

Example 10: Combining with IF and ISERROR

Data:

• A1: =1/0 (This will result in an error)

Formula:

• B1: =IF(NOT(ISERROR(A1)), A1, "Error Detected")

Result:

• B1: Error Detected

These examples demonstrate various ways to use the NOT function in Excel, including combining it with other functions like IF, AND, OR, ISBLANK, and ISERROR.