Rounding to Nearest 500

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Does anyone know how to round to the nearest "500". I thought this would
be a simple rounding procedure but its more complicated than
anticipated...somebody save what's left of my weekend!
 
Bill, with your number in A1, try this =ROUND(A1/500,0)*500

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Does anyone know how to round to the nearest "500". I thought this would
be a simple rounding procedure but its more complicated than
anticipated...somebody save what's left of my weekend!
Click to expand...


=ROUND(A1/500,0)*500


--ron
 
Bill said:
Does anyone know how to round to the nearest "500". I thought this would
be a simple rounding procedure but its more complicated than
anticipated...somebody save what's left of my weekend!
Click to expand...
 
An alternative is using one of the Analysis ToolPak functions...

=MROUND(A3,500)

where:

A3 = the cell containing the number you want rounded
500 = the multiple you want rounded to

To use this function, you have to enable the toolpak (only once):
1.. On the Tools menu, click Add-Ins.
2.. In the Add-Ins available list, select the Analysis ToolPak box, and
then click OK.
You may be asked to insert the Office CD or have a "first install" process
to go through, but once installed/enabled, a host of extra functions are
available from then on.
 
Bill said:
Does anyone know how to round to the nearest "500". I thought this would
be a simple rounding procedure but its more complicated than
anticipated...somebody save what's left of my weekend!
Click to expand...

Just another alternative.

=ROUND(X*2,-3)/2
 
Back
Top