# FLOOR.MATH

The `FLOOR.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.

## Usage

Use the `FLOOR.MATH` formula with the syntax shown below, it has 1 required parameter and 2 optional parameters:

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

Here are a few example use cases that explain how to use the `FLOOR.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, 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.

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.

You can learn more about the `FLOOR.MATH` Google Sheets function on Google Support.