The **FLOOR MATH** (FLOOR.MATH) function is a *Math* formula that rounds a given number down to the nearest multiple of significance. This function was released in Excel 2013 as a replacement for the **FLOOR** function. In this guide, we’re going to show you how to use the **FLOOR MATH** function and also go over some tips and error handling methods.

## Supported versions

- Excel 2013 and newer versions

## FLOOR MATH Function Syntax

## Arguments

number |
The number you want to round down. |

[significance] |
Optional. The multiple to which you want to round. Default is 1. |

[mode] |
Use a negative number to change direction of the rounding for negative numbers. |

Examples

### Rounding down to the nearest integer

If both optional arguments are omitted, the **FLOOR MATH** function rounds the **number** argument down to the nearest integer. The direction is away from 0 for negative numbers as well.

### Rounding down to the nearest multiple of significance

Enter a **[significance] **value to round the **number **down to a specific multiple. You can use decimal values or integers. If you add the **[significance]** without the **[mode]** argument, **FLOOR MATH** rounds negative numbers away from zero by default.

### Rounding down to the nearest multiple of significance by mode

The **[mode]** argument specifies the rounding direction only for __negative__ numbers. Any value other than zero (0), the default value, reverts the direction. Thus, the **FLOOR MATH **function will round negative numbers towards zero.

=FLOOR.MATH(-23.254,-0.04,0) returns -23.28

## Summary and Tips

- Excel introduced the
**FLOOR****MATH**function as the successor of the**FLOOR**function. The support for**FLOOR**function continues for the sake of backwards compatibility. - Use the
**CEILING.MATH**function to round up to the nearest multiple. - If you need to round to nearest multiple, up or down, use
**MROUND.** - The
**[mode]**argument doesn’t have any effect on positive numbers.