NOT (!)

The following section describes the syntax and usage of the NOT (!) function in ActivityInfo.

Description

The NOT (!) function is used to reverse a logical value - i.e. if a condition returns a TRUE, using NOT will change its value to FALSE, and vice versa.

Syntax

 !(condition)

Argument Required Description
condition Yes The condition whose logical value you wish to reverse.

The condition must evaluate to TRUE or FALSE.

Result

  • TRUE if the condition evaluates to FALSE.
  • FALSE if the condition evaluates to TRUE.
  • NA if the condition is not a logical value (TRUE/FALSE).

Example

We will be using the NOT function to reverse the return value of a condition. The condition in this case is a test of whether a value is numeric, using the IS NUMBER function. We will then use the IF function to return a value.

Arguments

We will be using the Quantity Field "Age" with Field code "AGE". Note the blank entry between the "21" and "18" values.

Formula

IF(!ISNUMBER(AGE),1,0)

Results