## Explanation

The Excel CEILING function rounds a number *up* to a given multiple. The multiple to use for rounding is given as the second argument (*significance*). If the number is already an exact multiple, no rounding occurs. CEILING works like the MROUND function, but unlike MROUND, which rounds to the *nearest* multiple, CEILING always rounds *up* to the given multiple.

In the example shown, the formula in cell D6 is

```
=CEILING(B6,C6)
```

This tells Excel to take the value in B6 ($33.39 ) and round it to the nearest multiple of the value in C6 (5). The result is $35.00, since 35 is the next multiple of 5 after 33.39. In cell D10, we are rounding the same number, 33.39 up to the nearest multiple of 1 and get 34.00.

You can use CEILING to round prices, times, instrument readings or any other numeric value.

CEILING rounds *up* using the multiple supplied. You can use the MROUND function to round to the *nearest multiple* and the FLOOR function to round* down* to a multiple.