FLOOR Function
Rounds a number toward 0 (zero), to the next integer, or to the next instance of multiple.
Syntax
FLOOR(number, multiple)
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
number |
Required |
Number |
The number to round. |
multiple |
Required |
Number |
The multiple to which to round. |
Return Value
Number
Remarks
If multiple is not specified, the number rounds toward 0 to the next integer.
Number and multiple must have the same signs, or a #NUM! error is returned. If either number or multiple cannot be converted to a value, a #VALUE! error is returned. If either number or multiple is 0, the result is 0.
Example 1
FLOOR(3.7)
Returns 3.
Example 2
FLOOR(-3.7)
Returns -3.
Example 3
FLOOR(3.7, 0.5)
Returns 3.5.