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.

Additional Notes

FLOOR.MATH is versatile for rounding calculations in various contexts, including data analysis and financial modeling.
It offers improved functionality over the traditional FLOOR function, especially with the added control for rounding negative numbers.
The function is essential in scenarios where precision in rounding to specific increments is required.