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
