M
mgtyper
How would I Round up to 5 as in
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 12
10.1 to 15
9.9 to 10
105.3 to 110
123.6 to 12
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ron Rosenfeld
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
C
chris.cudmore
=roundup( A1/5,0) *5
C
chris.cudmore
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.
Mine will round -101 to -105
Ron's will round -101 to -100
Take your pick depending on how you want to handle negatives.
P
paul
another way
=MROUND(E7+2.5,5)
=MROUND(E7+2.5,5)
D
daddylonglegs
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)
M
mgtyper
Thanks guys that works perfect