Name

range — Classifies a number in to a numeric range category.

Syntax

range(number, classbreak1, ..., classbreakN)
              

The RANGE function has the following argument:

lookup

The numeric value to be conterted to a range category.

classbreak1

The first class break. Lookup values less the first class break will be labeled 'Less than N' (where N is the first classbreak value).

classbreakN

Subsequent class breaks must be in ascending order. Lookup values that are greater than or equal to a first classbreak (N1) but less than the next classbreak (N2) are labeled 'N1 - N2'. Lookup value greater than or equals to the last class break are labeled 'N plus'.

Description

This converts a number in to a numeric range category. The lookup value is compared to the class break values. If the lookup value is less than the first class break then the function will return 'Less than N', where N is the first class break value. If the lookup value is greater than or equal to the last class break then the function will return 'N plus', where N is the last class break. Lookup values that are greater than or equal to a classbreak (N1) but less than the next classbreak (N2) are labeled 'N1 - N2'.

The lookup value and all class break values must be numeric.

Class break values must be in increaseing order.

Examples

Formula

Description

Result

range(-1, 0,5,10,15)

Determine the range label for -1.

'Less than 0.0'

range(1, 0,5,10,15)

Determine the range label for 1.

'0.0 - 5.0'

range(100, 0,5,10,15)

Determine the range label for 100.

'15.0 plus'