What is the syntax for FLOOR.MATH in Excel?

The syntax for FLOOR.MATH is: =FLOOR.MATH(number, [significance], [mode])

How do I use the FLOOR.MATH function?

To use FLOOR.MATH, type =FLOOR.MATH( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if FLOOR.MATH encounters errors?

If FLOOR.MATH encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is FLOOR.MATH not working in my Excel?

Common issues with FLOOR.MATH include Returns 0 if significance is 0. Start by checking the syntax =FLOOR.MATH(number, [significance], [mode]), then verify each referenced cell or range.

Math & Trig

FLOOR.MATH Function in Excel

Rounds a number down to the nearest integer or to the nearest multiple of significance.

Syntax

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

Arguments

number (required): Number to round down
significance (optional): Multiple to round to
mode (optional): Direction for negative numbers

Examples

=FLOOR.MATH(6.7) - Round down to integer - Result: 6
=FLOOR.MATH(-6.7, 2, 1) - Round negative toward zero - Result: -6

FLOOR.MATH in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

Returns 0 if significance is 0

Use cases

Rounding down
Pricing
Time intervals

Frequently asked questions

What is the FLOOR.MATH function in Excel? FLOOR.MATH rounds a number down to the nearest integer or to the nearest multiple of significance. The syntax is =FLOOR.MATH(number, [significance], [mode]). Typical use cases include rounding down, pricing, time intervals.
How do I use the FLOOR.MATH function? To use FLOOR.MATH, type =FLOOR.MATH( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if FLOOR.MATH encounters errors? If FLOOR.MATH encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is FLOOR.MATH not working in my Excel? Common issues with FLOOR.MATH include Returns 0 if significance is 0. Start by checking the syntax =FLOOR.MATH(number, [significance], [mode]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.