To use this function, choose Calc > Calculator.

Rounds a number down based on the number of decimal places you specify.

Tip

Use the Ceiling function to round up.

Syntax

FLOOR(number,decimals)

For number, specify the number or column of numbers you want to round. For decimals, specify the number of places to round to:
  • If decimals = 0, the number is rounded to the nearest integer less than or equal to the number.
  • If decimals > 0, the number is rounded down to the specified number of decimal places after the decimal point.
  • If decimals < 0, the number is rounded down to 1 minus the specified number of place values to the left of the decimal point.

Examples

Calculator expression Result
FLOOR (2.136, 0) 2
FLOOR (2.136, 1) 2.1
FLOOR (2.136, 2) 2.13
FLOOR (-2.136, 1) −2.2
FLOOR (253.6, −1) 250
FLOOR (253.6, −2) 200