[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 |
|
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:
FLOOR(2.5,1) rounds 2.5 down to nearest multiple of 1; that is, to 2
FLOOR(-2.5,-2) rounds -2.5 down to nearest multiple of -2; that is, to -2
FLOOR(1.5,0.1) rounds 1.5 down to the nearest multiple of 0.1; that is, to 1.5
FLOOR(0.234,0.01) rounds 0.234 down to the nearest multiple of 0.01; that is, to 0.23
end example]