To use this function, choose

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

Use the Ceiling function to round up.

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.

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 |