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.
|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.|