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

Example

=FLOOR( -11;-2) returns -12.

=FLOOR( -11;-2;0) returns -12.

=FLOOR( -11;-2;1) returns -10.