# FLOOR

### In this article

Rounds a number down, toward zero, to the nearest multiple of significance.

## Syntax

```
FLOOR(<number>, <significance>)
```

#### Parameters

Term | Definition |
---|---|

number | The numeric value you want to round. |

significance | The multiple to which you want to round. The argumentsnumber and significance must either both be positive, or both be negative. |

## Return value

A decimal number.

## Remarks

If either argument is nonnumeric, FLOOR returns **#VALUE!**error value.

If number and significance have different signs, FLOOR returns the **#NUM!**error value.

Regardless of the sign of the number, a value is rounded down when adjusted away from zero. If the number is an exact multiple of significance, no rounding occurs.

## Example

The following formula takes the values in the [Total Product Cost] column from the table, InternetSales.and rounds down to the nearest multiple of .1.

```
=FLOOR(InternetSales[Total Product Cost],.5)
```

The following table shows the expected results for some sample values.

Values | Expected Result |
---|---|

10.8423 | 10.8 |

8.0373 | 8 |

2.9733 | 2.9 |