Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 10th 08, 11:13 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 42
Default How can I round a number in Excel to the nearest 5000?

I would like to round a number in Excel to the nearest 5000. For example, if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!

  #2   Report Post  
Old September 10th 08, 11:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2,420
Default How can I round a number in Excel to the nearest 5000?

=ROUND(A20/50000,0)*50000

--
__________________________________
HTH

Bob

"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For example,
if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!



  #3   Report Post  
Old September 10th 08, 11:21 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 964
Default How can I round a number in Excel to the nearest 5000?

You mean round down, because if you have 53405 and round to the nearest 5000
you would get 55000?

To the nearest 5000

=ROUND(A1/5000,0)*5000

round down to the nearest 5000

=FLOOR(A1,5000)

--


Regards,


Peo Sjoblom

"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For example,
if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!



  #4   Report Post  
Old September 10th 08, 11:24 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default How can I round a number in Excel to the nearest 5000?

Try one of these:

A1 = some number

=ROUND(A1/5000,0)*5000

This one requires the Analysis ToolPak add-in be installed if you're using
versions of Excel prior to Excel 2007:

=MROUND(A1,5000)

--
Biff
Microsoft Excel MVP


"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For example,
if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!



  #5   Report Post  
Old September 10th 08, 11:30 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 4,393
Default How can I round a number in Excel to the nearest 5000?

Assuming a typo and you want 53405 - 55000 then use one of
=MROUND(A1,5000)
=ROUND(A1/5000,0)*5000
The first requires you have ToolPak loaded unless you are in XL2007

If there is no typo then try =INT(A3/5000)*5000
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For example,
if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!





  #6   Report Post  
Old September 10th 08, 11:39 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 42
Default How can I round a number in Excel to the nearest 5000?

My fault. I meant to say if the number is 53405 round to the nearest 5000
and you would get 55000. If the number is 52400 round to the nearest 5000
and you would get 50000.

"Peo Sjoblom" wrote:

You mean round down, because if you have 53405 and round to the nearest 5000
you would get 55000?

To the nearest 5000

=ROUND(A1/5000,0)*5000

round down to the nearest 5000

=FLOOR(A1,5000)

--


Regards,


Peo Sjoblom

"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For example,
if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!




  #7   Report Post  
Old September 11th 08, 09:24 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2008
Posts: 2,420
Default How can I round a number in Excel to the nearest 5000?

Then as Peo said,

=ROUND(A1/5000,0)*5000

--
__________________________________
HTH

Bob

"trainer07" wrote in message
...
My fault. I meant to say if the number is 53405 round to the nearest 5000
and you would get 55000. If the number is 52400 round to the nearest 5000
and you would get 50000.

"Peo Sjoblom" wrote:

You mean round down, because if you have 53405 and round to the nearest
5000
you would get 55000?

To the nearest 5000

=ROUND(A1/5000,0)*5000

round down to the nearest 5000

=FLOOR(A1,5000)

--


Regards,


Peo Sjoblom

"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For
example,
if
the number is 51285, then I want it to round to 50000. If the number
is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!








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 a number to the nearest 600 in Excel? Barcelona Excel Worksheet Functions 9 January 25th 07 10:51 PM
How do I round a number to the nearest thousand in Excel??? Round 123,456 to read 123 Excel Discussion (Misc queries) 3 September 14th 06 04:59 PM
Round to nearest 5000? Kim Excel Worksheet Functions 2 August 8th 06 02:16 AM
Round to nearest 5000 Woody13 Excel Discussion (Misc queries) 4 July 7th 06 09:34 PM
How can I round a number to the nearest "50" or "100" in excel 200 Manny Excel Worksheet Functions 2 July 29th 05 08:10 PM


All times are GMT +1. The time now is 09:43 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017