- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
FLOOR.MATH Function
Description
The FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of significance.
Syntax
FLOOR.MATH (number, significance, mode)
Arguments
| Argument | Description | Required/Optional |
|---|---|---|
| Number | The number to be rounded down. | Required |
| Significance | The multiple to which you want to round. | Optional |
| Mode | The direction (toward or away from 0) to round negative numbers. | Optional |
Notes
By default, positive numbers with decimal portions are rounded down to the nearest integer.
By default, negative numbers with decimal portions are rounded away from 0 to the nearest integer.
By using 0 or a negative number as the Mode argument, you can change the direction of the rounding for negative numbers.
The Significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer.
If Number is divided by a Significance of 2 or greater results in a remainder, the result is rounded down.
If any of the specified arguments is non-numeric, FLOOR.MATH returns #VALUE! Error.
Applicability
Excel 2013, Excel 2016
Example
