FLOOR
Syntax:
FLOOR ( x , significance )
Description: Computes x rounded down, toward zero, to the nearest multiple of significance. Regardless of the sign of x, a value is rounded down when adjusted away from zero.
Arguments:
Name |
Type |
Description |
|---|---|---|
x |
number |
The value to be rounded, |
significance |
number |
The multiple to which x is to be rounded. |
Return Type and Value: number – The rounded-down value of x.
However, if x and significance have different signs, #NUM! is returned.
example: