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.
You can then apply this formula to the rest of the cells.