# Nearest Multiple

Mround | Ceiling | Floor | Rounding Prices

This example illustrates three functions to **round** numbers to a **multiple** of x in **Excel**. **MROUND**, **CEILING** and **FLOOR**.

### Mround

1. For example, round a number to the nearest multiple of 10.

2. For example, round a number to the nearest multiple of 5.

### Ceiling

The same as MROUND but always rounds up.

### Floor

The same as MROUND but always rounds down.

### Rounding Prices

Need to adjust prices to make paying in cash easier? Use the MROUND function in Excel to round prices to coin values.

1. The MROUND function below rounds a price to the nearest nickel (5 cents).

2. The MROUND function below rounds a price to the nearest dime (10 cents).

3. The MROUND function below rounds a price to the nearest quarter (25 cents).