FLOOR function
FLOOR rounds a number down to the nearest multiple of significance.
Syntax
FLOOR(number,significance,mode)
- number is the number that is to be rounded.
- significance is the value to whose multiple the number is to be rounded.
- mode is an optional value. If the mode value is given and not equal to zero, and if number and significance are negative, rounding is done based on the absolute value of the number. The mode argument is ignored when exporting to Microsoft™ Excel, because it does not use a third parameter.
Important: If both number and significance are
negative, and if the mode value is equal to zero or is not specified, results in
IBM® Connections Docs and Microsoft Excel differ after exporting. If you export the spreadsheet to
Excel, use mode=1 to see the same results in Excel as in IBM Docs.
Example
=FLOOR( -11;-2) returns -12.
=FLOOR( -11;-2;0) returns -12.
=FLOOR( -11;-2;1) returns -10.