Math & Trig
Excel 2013
◉ 32 views
=FLOOR.MATH()
Round a number down to the nearest integer or to the nearest multiple of significance.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=FLOOR.MATH(number, significance, mode)
Hover argument names in the table for details.
Output typeNumber
Popularity35 / 100
VolatileNo
Dynamic ArrayNo
Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =FLOOR.MATH() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | The number to be rounded down. |
significance |
Number | Optional | The multiple to which you want to round. |
mode |
Number | Optional | The direction (toward or away from 0) to round negative numbers. |
▣ Examples
Rounds 24.3 down to the nearest integer that is a multiple of 5 (20).
=FLOOR.MATH(24.3,5)
Result:
20
Rounds 6.7 down to the nearest integer (6).
=FLOOR.MATH(6.7)
Result:
6
Rounds -8.1 down (away from 0) to the nearest integer that is a multiple of 2 (-10).
=FLOOR.MATH(-8.1,2)
Result:
-10
Rounds -5.5 toward 0 to the nearest integer that is a multiple of 2, using a non-zero Mode, which reverses rounding direction (-4).
=FLOOR.MATH(-5.5,2,-1)
Result:
-4
§ Remarks
- By default, positive numbers with decimal portions are rounded down to the nearest integer. For example, 6.3 is rounded down to 6, using the default Significance (1).
- By default, negative numbers with decimal portions are rounded away from 0 to the nearest integer. For example, -6.7 is rounded to -7.
- By using 0 or a negative number as the Mode argument, you can change the direction of the rounding for negative numbers. For example, rounding -6.3 with a Significance of 1 and a Mode of -1 rounds toward 0, to -6.
- The Significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer. For example, for a Significance of 3, the number is rounded down to the next integer that is a multiple of 3.
- If Number divided by a Significance of 2 or greater results in a remainder, the result is rounded down.
✦ Tips
- By default, positive numbers with decimal portions are rounded down to the nearest integer. For example, 6.3 is rounded down to 6, using the default Significance (1).
- By default, negative numbers with decimal portions are rounded away from 0 to the nearest integer. For example, -6.7 is rounded to -7.
- By using 0 or a negative number as the Mode argument, you can change the direction of the rounding for negative numbers. For example, rounding -6.3 with a Significance of 1 and a Mode of -1 rounds toward 0, to -6.
- The Significance argument rounds the number down to the nearest integer that is a multiple of the significance specified. The exception is where the number to be rounded is an integer. For example, for a Significance of 3, the number is rounded down to the next integer that is a multiple of 3.
- If Number divided by a Significance of 2 or greater results in a remainder, the result is rounded down.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!