FLOOR rounds a number down to the nearest multiple of significance.

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

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

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

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