FLOOR.MATH

The FLOOR.MATH function rounds a number down, towards zero, to the nearest multiple of a specified significance.

Syntax

=FLOOR.MATH(number, significance, [mode])

number The number you want to round down.
significance The multiple to which you want to round the number.
mode (Optional) An optional argument that controls how rounding is performed. Defaults to 0 if omitted.

About FLOOR.MATH

When you need to truncate a number towards zero and align it with a specific increment, trust the FLOOR.MATH function in Excel. It offers a simple yet powerful way to round down numbers to the nearest specified multiple. This is particularly useful when working with data that needs to be organized or categorized in a structured manner based on predefined thresholds or intervals. FLOOR.MATH efficiently handles this task by adjusting the input number downwards to conform to the selected significance level while respecting the chosen rounding mode, if specified.

Examples

To round the number 15.75 down to the nearest multiple of 5, you can use the formula: =FLOOR.MATH(15.75, 5) which will result in 15.

If you want to truncate the number -22.75 towards zero to the nearest multiple of 10 using the '1' mode (towards negative infinity), you can use: =FLOOR.MATH(-22.75, 10, 1) which gives -30.

Questions

How does the FLOOR.MATH function differ from the FLOOR function in Excel?

The FLOOR.MATH function allows you to specify the rounding mode (towards zero, negative infinity, or positive infinity) for more flexibility in rounding down numbers. On the other hand, the FLOOR function always rounds down towards negative infinity.

Can the FLOOR.MATH function handle negative numbers and decimals?

Yes, the FLOOR.MATH function can handle both negative and positive numbers, including decimals. It effectively rounds down any input number towards zero to the specified significance.

What happens if I omit the mode argument in the FLOOR.MATH function?

If you omit the mode argument in FLOOR.MATH, Excel will default to using mode '0', which means rounding towards negative infinity. This is the same behavior as the regular FLOOR function.

In what scenarios can the FLOOR.MATH function be useful?

The FLOOR.MATH function is handy for tasks such as budgeting, pricing strategies, or data categorization where precise rounding down to specific multiples is required. It helps ensure that numbers align with predefined intervals or thresholds for better organization and analysis.

Related functions

FLOOR
CEILING
CEILING.MATH
ROUND
MROUND