Floor - script and chart function
Floor() rounds down a number to the nearest multiple of the step shifted by the offset number.
Compare with the ceil function, which rounds input numbers up.
Syntax:
Floor(x[, step[, offset]])
Return data type: numeric
Arguments:
| Argument | Description |
|---|---|
| x | Input number. |
| step | Interval increment. The default value is 1. |
| offset |
Defines the base of the step interval. The default value is 0. |
Examples and results:
| Examples | Results |
|---|---|
|
Floor(2.4) |
Returns 2 In this example, the size of the step is 1 and the base of the step interval is 0. The intervals are |
|
Floor(4.2) |
Returns 4 |
|
Floor(3.88 ,0.1) |
Returns 3.8 In this example, the size of the interval is 0.1 and the base of the interval is 0. The intervals are |
|
Floor(3.88 ,5) |
Returns 0 |
|
Floor(1.1 ,1) |
Returns 1 |
|
Floor(1.1 ,1,0.5) |
Returns 0.5 In this example, the size of the step is 1 and the offset is 0.5. It means that the base of the step interval is 0.5 and not 0. The intervals are |