IS NUMBER

The following section describes the syntax and usage of the IS NUMBER function in ActivityInfo.

Description

The IS NUMBER function is used to determine whether a value is numeric - i.e. a number. 

Syntax

ISNUMBER(value)

Argument Required Description
value Yes The value you wish to test is numeric.

Result

  • TRUE if the value is a number.
  • FALSE if the value is not a number.

Example

We will be using the ISNUMBER function to evaluate whether a value is a number, and using 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 values "21" and "18".

Formula

IF(ISNUMBER(AGE),1,0)

Results