range

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'.

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.

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' |