Map and Table Calculation

INRANGE( ) function

Tests whether Value a is contained by a range or closed interval with endpoints Value b and Value c, i.e. b £ a £ c or a Î [b,c].

Syntax

INRANGE(Value a, Value b, Value c)

Input

Output

Note:

• The mathematical notation of the INRANGE function is: b ≤ a ≤ c.
• When one input value is undefined or when both input values are undefined, the output will also be undefined.

Tips:

• The INRANGE function is often used in combination with the conditional IFF function and relational operators, such as =, <, >, etc.
• When the definition symbol = is used, a dependent output map or dependent output column is created; when the assignment symbol := is used, the dependency link is immediately broken after the output map/column has been calculated.

Usable in

MapCalc, TabCalc, Simple calculators

Examples

Pocket line calculator examples:

MapCalc example:

OutMap = INRANGE(InMap,1200,1500)

OutMap = IFF(INRANGE(InMapA,1200,1500),InMapA,InMapB)

If a pixel in map InMapA has a value that is larger than or equal to 1200, and at the same time the value of this pixel is less than or equal to 1500, then the orginal value of map InMapA is assigned in output map OutMap. For other pixels, the value of the pixel in InMapB is assigned.

TabCalc example:

OutCol1 = INRANGE(InColA,1200,1500)

OutCol2 = IFF(INRANGE(InColA,1200,1500),InColA,IncolB)

OutCol3 = IFF(INRANGE(InColA,900,1300),"Inside","Outside")