Can you round up numbers to the nearest multiple of ten?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet that gives me the total number of people passing through
our gates each year for each site, however I need to round up the numbers to
the nearest mulitple of ten for our brochure numbers, is there an easy way to
do this or is it a case of putting them in manually/
 
You can us the Excel round funtion to round to the nearest multiple of ten.

For example if cell A1 contained the number 16, the function to round this
number to 20 would be: =round(A1,-1).

Hopefully this helps :-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding up to the nearest 1000 1
HOW TO ROUND UP INTEGER VALUES TO NEAREST TENS EXAMPLE 376 TO 380 4
Round numbers to get to the nearest 0.09 7
Alternate Rounding Up & Down of .50 in a column 5
How do I round a number to the nearest 600 in Excel? 9
How can you round a number to the nearest 900? 3
How do I get a calculated amount to round to the nearest nickel? 3
round numbers to the nearest quarter? 3

Back
Top