What Is The a formula to round up?

slick225 · Sep 16th 2004

Background: I have a cell with the value 18, I want to add a formula to round that up to next 10th, which would be 20.

Question:How can I do this?

Thanks in Advance

slick225 · Sep 16th 2004

Please Disregard this Post.
But for anyone wanting to know the answer:
=ROUNDUP(K5,-1)

Note:
K5 contains the value 18
results of the formula was 20

Brandtrock · Sep 17th 2004

FYI-

=ROUNDUP(K5.-1) will indeed give 20 when 18 is in K5. It will also give 20 when 11, 12, 13, 14 . . . 19 are in K5. If this won't cause you grief, OK.

If it will cause a problem, simply use ROUND(K5,-1). This gives 20 for values 15-19; and 10 for 11-14.

HTH

slick225 · Sep 20th 2004

Thanks for the follow up, but Rounding up to the next 10 is exactly what I was trying to do. The calucation I needed requireds that sum of a series of numbers and then those numbers be rounded up to the 10th spot.

but, thanks again for the heads up.

What Is The a formula to round up?

Participate now!

Share

Users Viewing This Thread