SOLVED

# Roundoff values (not for decimals)

Occasional Contributor

# Roundoff values (not for decimals)

I need to round off values based on my calculation to the next multiple of 10. For eg.. if my calculation returns a value 42 it should be rounded to 50, 58 to 60, 71 to 80.

How can this be done.

5 Replies

# Re: Roundoff values (not for decimals)

@Rudrabhadra Let's say the number is in A1, then use this formula:

``=ROUNDUP(A1,-1)``

# Re: Roundoff values (not for decimals)

Thanks it works .... could you please help me how it works as we are giving -1...
Just out of curiosity ... how can we round it to multiple of 5 or 10... like if it is 43 to 45, 48 to 50, 51 to55...

# Re: Roundoff values (not for decimals)

It could be

``=CEILING(A1,5)``
best response confirmed by Rudrabhadra (Occasional Contributor)
Solution

# Re: Roundoff values (not for decimals)

@Rudrabhadra Well, you ask for rounding up to the next 10. That's what -1 does. A -2 rounds to the next 100, -3 to the next 1000 and so on.

Rounding up to the next multiple of 5 would be:

=CEILING(A1,5)

And that, of course, works for every other multiple you would want to use.

Thanks a lot...