range1(X;S;E;I)
Returns the upper bound of the particular interval in which a given value falls within a specified range of values.
Syntax
range1(X;S;E;I)Input
| Argument | Type | Description |
|---|---|---|
X |
any numeric type | The value on which to determine the upper bound of the interval |
S |
integer or decimal | The starting value of the range |
E |
integer or decimal | The ending value of the range |
I |
integer or decimal | The length of the interval |
Return Value
Returns a numeric value corresponding to the upper bound of 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.
If X is N/A, the result is N/A.
Sample Usage
value |
start |
end |
interval |
range1(value;start;end;interval) |
|---|---|---|---|---|
| -15 | -20 | 100 | 10 | -10 |
| -5 | 0 | 100 | 10 | 0 |
| 13 | 0 | 100 | 10 | 20 |
| 13 | 0.25 | 100 | 10 | 20.25 |
| 200 | 0 | 100 | 10 | |
| 0 | 100 | 10 |