FLOOR.MATH
TheFLOOR.MATH
formula rounds a number down to the nearest integer or to the nearest multiple of a specified significance, depending on the mode. This formula is commonly used in financial and accounting applications to round down a number to a specific decimal place or to the nearest dollar or thousand. The FLOOR.MATH
formula is similar to the FLOOR
formula, but it provides more flexibility in terms of rounding to a specific significance and choosing the rounding mode.
 How to use
FLOOR.MATH
formula?  Examples of using
FLOOR.MATH
formula FLOOR.MATH
formula not working? Similar formulas to
FLOOR.MATH
Usage
Use the FLOOR.MATH
formula with the syntax shown below, it has 1 required parameter and 2 optional parameters:
 number (required):
The number or reference to a cell containing a number that you want to round down.  significance (optional):
The multiple to which you want to round down. If omitted, the function rounds down to the nearest integer.  mode (optional):
The rounding mode to use. If omitted, the function uses the default mode of 0. The possible values are 0, 1, and 1, which correspond to rounding down, rounding up, and rounding towards zero, respectively.
Examples
Here are a few example use cases that explain how to use theFLOOR.MATH
formula in Google Sheets.
Rounding down to the nearest integer
Use FLOOR.MATH
to round a number down to the nearest integer, which is useful for converting decimals to whole numbers or for truncating a number to a specific number of decimal places.
Rounding down to a specific significance
Use FLOOR.MATH
with a specified significance to round a number down to the nearest multiple of that significance. This is useful for rounding to a specific decimal place, such as rounding down to the nearest dollar or to the nearest thousand.
Rounding negative numbers down
The default rounding mode of FLOOR.MATH
is to round towards negative infinity, which means that negative numbers are rounded down to the nearest integer or multiple of a significance. This is useful for financial applications where negative numbers represent expenses or debts.
Common Mistakes
FLOOR.MATH
not working? Here are some common mistakes people make when using the FLOOR.MATH
Google Sheets Formula:
Incorrect number of arguments
One of the most common mistakes when using FLOOR.MATH is providing an incorrect number of arguments. The function requires at least one argument (the number to be rounded down) and can accept up to three arguments. If you forget to include an argument or provide too many, you will get an error message. To correct this mistake, doublecheck the syntax of your formula and make sure you have the correct number of arguments.
Invalid argument types
Another common mistake when using FLOOR.MATH is providing invalid argument types. The function requires a number as its first argument and can accept two optional numeric arguments. If you provide a nonnumeric argument, you will get an error message. To correct this mistake, make sure that all of your arguments are numeric values.
Incorrect use of the mode argument
The mode argument in FLOOR.MATH specifies how to round the number down. If you do not provide a value for the mode argument, the function will default to mode 0 (round towards negative infinity). If you provide an invalid value for the mode argument, you will get an error message. To correct this mistake, make sure you are using the correct mode value (0, 1, or 2) and that you understand how each mode works.
Significance argument is not a power of 10
If you provide a significance argument that is not a power of 10 (e.g. 3 or 7), you will get an error message. The significance argument in FLOOR.MATH specifies the multiple to which you want to round the number down. To correct this mistake, make sure you are using a power of 10 for the significance argument (e.g. 10, 100, 1000).
Incorrect use of the significance argument
The significance argument in FLOOR.MATH is optional and specifies the multiple to which you want to round the number down. If you provide a significance argument that is larger than the number you are rounding down, the function will return 0. If you provide a significance argument that is smaller than the number you are rounding down, the function will round down to the nearest multiple of the significance argument. To correct this mistake, make sure you are using the significance argument correctly and that you understand how it affects the rounding process.
Related Formulas
The following functions are similar to FLOOR.MATH
or are often used with it in a formula:

FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.

CEILING.MATH
The
CEILING.MATH
formula in Google Sheets rounds a given number up to the nearest multiple of a specified significance. This function is typically used to round up numbers to the nearest multiple of a certain value, such as when dealing with pricing or quantities. 
ROUND
The
ROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If theplaces
parameter is not specified, the formula rounds to the nearest integer. 
INT
The
INT
formula rounds a given value down to the nearest integer. This formula is often used to simplify large numbers or to convert decimal values to integers. The formula takes a single parameter, the value to be rounded down. If the value is already an integer, the formula will return the same value. If the value is a decimal, the formula will round down to the nearest integer.
Learn More
You can learn more about the FLOOR.MATH
Google Sheets function on Google Support.