Rounding to 5.0 or 0.0
 

How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 125


--
mgtyper
------------------------------------------------------------------------
mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402
View this thread: http://www.excelforum.com/showthread...hreadid=570891

Rounding to 5.0 or 0.0
 

On Fri, 11 Aug 2006 14:58:52 -0400, mgtyper
wrote:


How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 125

Try:

=CEILING(A1,5)


--ron

Rounding to 5.0 or 0.0
 

=roundup( A1/5,0) *5



mgtyper wrote:
How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 125


--
mgtyper
------------------------------------------------------------------------
mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402
View this thread: http://www.excelforum.com/showthread...hreadid=570891

Rounding to 5.0 or 0.0
 

Both these answers will work in the positive domain.

Mine will round -101 to -105
Ron's will round -101 to -100

Take your pick depending on how you want to handle negatives.



wrote:
=roundup( A1/5,0) *5



mgtyper wrote:
How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 125


--
mgtyper
------------------------------------------------------------------------
mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402
View this thread: http://www.excelforum.com/showthread...hreadid=570891

Rounding to 5.0 or 0.0
 

another way
=MROUND(E7+2.5,5)
--
paul

remove nospam for email addy!



"mgtyper" wrote:


How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 125


--
mgtyper
------------------------------------------------------------------------
mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402
View this thread: http://www.excelforum.com/showthread...hreadid=570891

Rounding to 5.0 or 0.0
 

Wrote:
Both these answers will work in the positive domain.

Mine will round -101 to -105
Ron's will round -101 to -100

Take your pick depending on how you want to handle negatives.



Hi Chris

=CEILING(A1,5)

doesn't work for negative values, you need to use

=CEILING(A1,-5)

and then this will give the same result as your ROUNDUP formula

To make CEILING work for negative or positive values

=CEILING(A1,SIGN(A1)*5)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=570891

Rounding to 5.0 or 0.0
 

Thanks guys that works perfect.


--
mgtyper
------------------------------------------------------------------------
mgtyper's Profile: http://www.excelforum.com/member.php...o&userid=37402
View this thread: http://www.excelforum.com/showthread...hreadid=570891