# ROUNDDOWN

Rounds a number down, toward zero.

## Syntax

```
ROUNDDOWN(<number>, <num_digits>)
```

### Parameters

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

number | A real number that you want rounded down. |

num_digits | The number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer. |

## Return value

A decimal number.

## Remarks

If

**num_digits**is greater than 0 (zero), then the value in**number**is rounded down to the specified number of decimal places.If

**num_digits**is 0, then the value in**number**is rounded down to the nearest integer.If

**num_digits**is less than 0, then the value in**number**is rounded down to the left of the decimal point.ROUNDDOWN behaves like ROUND, except that it always rounds a number down. The INT function also rounds down, but with INT the result is always an integer, whereas with ROUNDDOWN you can control the precision of the result.

## Example 1

The following example rounds 3.14159 down to three decimal places. The expected result is 3.141.

```
= ROUNDDOWN(3.14159,3)
```

## Example 2

The following example rounds the value of 31415.92654 down to 2 decimal places to the left of the decimal. The expected result is 31400.

```
= ROUNDDOWN(31415.92654, -2)
```