# Excel FLOOR.MATH function

## Summary

The Excel FLOOR.MATH function rounds a number down to the nearest integer or to the nearest multiple of specified significance. Similar to the CEILING.MATH function, FLOOR.MATH enhances the classic FLOOR function by providing additional control over the direction and multiple of rounding. This function is used in various mathematical, financial, and statistical applications where rounding down to a specific increment is necessary.
##### Syntax
```				```
=FLOOR.MATH(number, [significance], [mode])
```
```
• number: The numeric value to round down.
• [significance]: [Optional] The multiple to round down to. Defaults to 1 if omitted.
• [mode]: [Optional] Determines how negative numbers are rounded: 0 (or FALSE) rounds away from zero, 1 (or TRUE) rounds toward zero. Default is 0.
##### Return value
A number rounded down to the nearest integer or specified multiple of significance.

## How to use

Use FLOOR.MATH to round a number down to the nearest integer or to a specific multiple. If the significance is not specified, it defaults to 1. The mode argument allows for additional control over rounding negative numbers.

## Examples

##### Simple FLOOR.MATH
Rounding Down to Nearest Integer: To round a number down to the nearest integer:
```				```
=FLOOR.MATH(7.3)
```
```
This formula rounds the number 7.3 down to the nearest integer, resulting in 7.
##### FLOOR.MATH with Significance
Rounding Down to Nearest Multiple of 5: To round a number down to the nearest multiple of 5:
```				```
=FLOOR.MATH(7, 5)
```
```
Rounds the number 7 down to the nearest multiple of 5, resulting in 5.
##### FLOOR.MATH for Financial Calculations
Rounding Prices to Nearest Dollar: To round a price down to the nearest whole dollar:
```				```
=FLOOR.MATH(49.25)
```
```
Rounds the amount \$49.25 down to the nearest dollar, resulting in \$49.
##### FLOOR.MATH with Negative Numbers
Rounding Negative Numbers Toward Zero: To round a negative number down toward zero:
```				```
=FLOOR.MATH(-5.5, 1, 0)
```
```
This rounds -5.5 down toward zero to -5.
##### FLOOR.MATH in Data Analysis
Using FLOOR.MATH in Data Grouping: To group data values into bins of specified size:
```				```
=FLOOR.MATH(A2, 10)
```
```
Assuming A2 contains a value, this formula rounds it down to the nearest multiple of 10 for grouping.