*Quick roundup/down Question

[nrguerrieri]

I want 172 to round to 175

187 to 190.

Can excel rounding function round like that? If so, what would the formula be?

I tried =roundup(cell,-1) for the first example here, but it rounded to 180.

 

[Rick Rothstein]

Assuming your values are always integers, give this formula a try...

=ROUNDUP(MROUND(2.49+A1,5),0)

 

[Rick Rothstein]

Assuming your values are always integers, give this formula a try...

=ROUNDUP(MROUND(2.49+A1,5),0)

Actually, this simpler formula should do the same thing...

=CEILING(A1,5)