Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tilly
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RJ
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tilly
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I round to the nearest 5? JoeBed Excel Worksheet Functions 2 April 28th 06 02:34 PM
Format Round to Nearest Thousand GillianHG Excel Discussion (Misc queries) 3 March 21st 06 07:43 PM
Round to nearest thousand GillianHG Excel Discussion (Misc queries) 3 March 15th 06 07:06 PM
Sorting Numbers with Multiple Decimals (cont.) Intern Ian Excel Discussion (Misc queries) 5 September 21st 05 12:04 AM
Rounding numbers to the nearest thousand Mark Excel Discussion (Misc queries) 2 March 10th 05 01:13 PM


All times are GMT +1. The time now is 11:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"