# 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 Connections Docs.## Example

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

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

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