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.

In excel you can use the Round formula to round a number up or down to your desired amount, allowing you to optimise both time, and data management through cutting tedious tasks.


round a number in excel

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

Round a number in excel