range1f(X;S;E;I;D)
Returns the textual representation of the interval in which a given value falls within a specified range of values.
Syntax
range1f(X;S;E;I;D)Input
| Argument | Type | Description |
|---|---|---|
X |
any numeric type | A scalar value or the name of a column |
S |
any numeric type | The starting value of the range |
E |
any numeric type | The ending value of the range |
I |
any numeric type | The length of the interval |
D |
integer | The number of decimal places to display in the results |
Return Value
Returns a text value corresponding to the interval in which X falls. The
range of values is defined by the starting value S and the ending value
E; the length of each interval is defined by I. The
values are shown with D decimal places, which ensures that items line up
properly when sorting.
If X is N/A, the result is the string
'N/A'.
Sample Usage
value |
start |
end |
interval |
decimals |
range1f(value;start;end;interval;decimals) |
|---|---|---|---|---|---|
| -15 | -20 | 100 | 10 | 2 | '-19.99- -10.00' |
| -5 | 0 | 100 | 10 | 2 | '<= 0.00' |
| 13 | 0 | 100 | 10 | 2 | '10.01- 20.00' |
| 13 | 0.25 | 100 | 10 | 2 | '10.26-20.25' |
| 200 | 0 | 100 | 10 | 2 | '> 100.00' |
| 0 | 100 | 10 | 2 | 'N/A' |