FLOOR.MATH

• 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:

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

1. number (required):
   The number or reference to a cell containing a number that you want to round down.
2. significance (optional):
   The multiple to which you want to round down. If omitted, the function rounds down to the nearest integer.
3. 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

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

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, double-check 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 non-numeric 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 the places 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.