How can we help?


Give us a call

Our team of experts are on hand and ready to help.

0161 883 2655

Live chat

Ready to chat data? That's what we're here for


Submit an enquiry

Fill out your details and one of the team will be in touch

Get in touch

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.

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


Our blog

Get up to speed on what’s happening in the world of Data…