How to Round a Number in Excel

In excel you can use the Round formula to round a number up or down to your desired amount. In the example below there are 7 employees A to G and their monthly sales total. This is how you would round these numbers up to the nearest £1.

Using the formula =ROUND(C3/1,0)*1 you can easily round the monthly sales total to the nearest £1.

round a number in excel

You can then apply this formula to the rest of the cells.

Round a number in excel