Forum Discussion
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.
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.
5 Replies
Rudrabhadra Let's say the number is in A1, then use this formula:
=ROUNDUP(A1,-1)- 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...
Thanks in advanceRudrabhadra 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.
