FLOOR function

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



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.

Trademarks | IBM Connections wiki