SheetFX
≡
<< Go back to all functions

NOT

The NOT function in Google Sheets is used to return the opposite of a logical value. If the logical expression is TRUE, the function returns FALSE, and if the logical expression is FALSE, the function returns TRUE.

Function Syntax and Parameters

Syntax: NOT(logical_expression)

Parameters:

  • logical_expression: The logical value or expression to evaluate.

Step-by-Step Tutorial

  1. Using NOT with a logical expression:

    • Example: =NOT(TRUE)
    • Result: FALSE

  2. Using NOT with a logical expression:

    • Example: =NOT(FALSE)
    • Result: TRUE

Use Cases and Scenarios

  1. Conditional Formatting: Invert cell formatting based on a specific condition.
  2. Data Validation: Create a custom validation formula that returns the opposite of the expected result.
  3. Logical Comparisons: Use NOT to reverse the outcome of logical comparisons.

Related Functions

  • AND: Returns true if all of the provided arguments are logically true.
  • OR: Returns true if any of the provided arguments are logically true.

Related Articles