Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you round up numbers to the nearest multiple of ten?
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/ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you round up numbers to the nearest multiple of ten?
Try
=ROUNDUP(A1,-1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tilly" wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you round up numbers to the nearest multiple of ten?
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 :-) "Tilly" wrote: 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/ |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you round up numbers to the nearest multiple of ten?
Thanks that's great, worked a treat!
"Chip Pearson" wrote: Try =ROUNDUP(A1,-1) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tilly" wrote in message ... 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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I round to the nearest 5? | Excel Worksheet Functions | |||
Format Round to Nearest Thousand | Excel Discussion (Misc queries) | |||
Round to nearest thousand | Excel Discussion (Misc queries) | |||
Sorting Numbers with Multiple Decimals (cont.) | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) |