Jul 26 2022 10:10 PM
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.
Jul 26 2022 10:37 PM
@Rudrabhadra Let's say the number is in A1, then use this formula:
=ROUNDUP(A1,-1)
Jul 27 2022 01:21 AM
Jul 27 2022 01:49 AM
Jul 27 2022 01:50 AM
Solution@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.
Jul 27 2022 01:50 AM
Solution@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.