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