ExcelMathBeginner

FLOOR.MATH

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

Read the syntaxReview worked examplesOpen the spreadsheet app
=FLOOR.MATH(number, [significance], [mode])
Open Spreadsheet Explorer

This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.

What the function does

Overview

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

FLOOR.MATH offers enhanced control over rounding down, particularly for negative numbers, compared to the traditional FLOOR function. It rounds a number down, towards zero, to the nearest multiple of `significance`. If `significance` is omitted, it defaults to 1. The optional `mode` argument dictates how negative numbers are rounded. If `mode` is 0 or omitted, negative numbers are rounded down (away from zero). If `mode` is any non-zero value, negative numbers are rounded towards zero. This function is ideal for scenarios requiring consistent rounding logic across both positive and negative values, such as financial calculations or inventory management. For example, FLOOR.MATH(-2.7, 0.5, 1) would return -2.5 (towards zero), whereas FLOOR.MATH(-2.7, 0.5) or FLOOR.MATH(-2.7, 0.5, 0) would return -3.0 (away from zero).

Quick reference

Syntax

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

Inputs

Arguments

numberThe number you want to round.
Example: A2
significance (optional)The multiple to which you want to round. Defaults to 1 if omitted.
Example: 0.1
mode (optional)A value that specifies whether to round negative numbers toward or away from zero. If 0 or omitted, rounds away from zero. If any non-zero value, rounds toward zero.
Example: 1

Formula patterns

Examples

1

Round Down Positive Number

=FLOOR.MATH(4.7, 1)
roundingpositive numbers
2

Round Down Negative Number (towards zero)

=FLOOR.MATH(-4.7, 1, 1)
roundingnegative numbersmode

Avoid these issues

Common Errors

1

#VALUE!

Cause: One or more arguments are non-numeric.

Fix: Ensure 'number', 'significance', and 'mode' (if used) are valid numeric values or references to cells containing numbers.

2

Unexpected Result

Cause: Misunderstanding of how the 'mode' argument affects negative numbers.

Fix: Carefully consider whether negative numbers should round towards or away from zero and set the 'mode' argument accordingly (0 or omitted for away, non-zero for towards).

Platform support

Compatibility

Excel 2013+Google Sheets

Introduced in Excel 2013. Recommended over FLOOR for improved flexibility with negative numbers.

Source: Microsoft Support

Common questions

Frequently Asked Questions

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

number: The number you want to round. significance: The multiple to which you want to round. Defaults to 1 if omitted. mode: A value that specifies whether to round negative numbers toward or away from zero. If 0 or omitted, rounds away from zero. If any non-zero value, rounds toward zero.

#VALUE!: Ensure 'number', 'significance', and 'mode' (if used) are valid numeric values or references to cells containing numbers. Unexpected Result: Carefully consider whether negative numbers should round towards or away from zero and set the 'mode' argument accordingly (0 or omitted for away, non-zero for towards).