Floor rounds a number down to the nearest specified significance.
Floor( [Number], [Significance] )
Number is the number to round.
The significance is the number to which this function finds the nearest (lower valued) multiple of.
Rule | Meaning |
|---|---|
| Floor(123.456, 9) | Rounds the number 123.456 down to the nearest multiple of 9. The resulting value is 117. |
| Floor(-1.234,1) | Rounds the number -1.234 down to the nearest multiple of 1. The resulting value is -2. |