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.

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.

Related Functions

Excel FLOOR function

The Excel FLOOR function rounds numbers down to the nearest multiple of significance, useful for inventory and budget control.

Excel ROUNDDOWN function

The Excel ROUNDDOWN function rounds a number down, away from zero, to a specified number of digits, useful for conservative estimations.

Excel CEILING function

The Excel CEILING function rounds numbers up to the nearest multiple of significance, ideal for pricing and budgeting calculations.

Excel ROUNDUP function

The Excel ROUNDUP function rounds a number up, away from zero, to a specified number of digits, ideal for precautionary measures in calculations.

Excel ROUND function

The Excel ROUND function rounds a number to a specified number of digits, crucial for accurate financial and scientific calculations.

Excel CEILING.MATH function

The Excel CEILING.MATH function rounds numbers up to the nearest integer or multiple, versatile for financial calculations.

Content Navigation