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 🔗
Use the FLOOR.MATH function in Excel to truncate a number towards zero and align it with a specific increment. This function helps you round down numbers to the nearest specified multiple. It's useful for organizing or categorizing data based on predefined thresholds or intervals. FLOOR.MATH adjusts the input number downwards to match the selected significance level and respects the chosen rounding mode, if specified.
Examples 🔗
=FLOOR.MATH(15.75, 5) rounds the number 15.75 down to the nearest multiple of 5, resulting in 15.
=FLOOR.MATH(-22.75, 10, 1) truncates the number -22.75 towards zero to the nearest multiple of 10 using the '1' mode (towards negative infinity), resulting in -30.
Notes 🔗
Ensure that the input number and significance value are appropriate for your calculations. If you need to customize the rounding behavior, consider using the optional mode parameter to suit your specific requirements.
Questions 🔗
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.