1. Calculation functions
  2. All Functions
  3. Logical Functions
  4. NOT

Tests to see if a condition is not met.

Syntax

NOT(x) 

where:

  • x: Line item to test

Format

Input Format Output Format

x: Number, Boolean, date, time period, list item, text

Boolean

Arguments

The function uses the following arguments:

  • x:
Number: Numeric line item, property, or expression
  Boolean: Expression that equates to a Boolean result
  Hard-coded date, date variable, or line item—Time period

Constraints

The function has the following constraints:

  • The result cell must be formatted as a Boolean check box - The check box is checked if TRUE.

Excel equivalent

Back to Top

Example

The example below tests to see if the condition is NOT met. The result is shown in a Boolean check box that is TRUE if x is not greater than 1500.

NOT (x > 1500)

Back to Top

Similar functions