Rounding Up only.

Saj

How to round up to next 10 only even if it's under 5. I've used Roundup but that didn't worked.

Andy_B

Hi @Saj,

You were on the right track with the ROUNDUP function, but when you put a 10 after the Total@row, you are asking it to round to the nearest tenth decimal place (100.0000000000).

To round to the tens place (100.0) you need to use a negative one in your formula:

=ROUNDUP(Total@row, -1)

This will give the following result:

If you want the four rows with 100 to round up to 110, you can add the following modification to your formula:

=IF(RIGHT(Total@row, 1) = 0, ROUNDUP(Total@row, -1) + 10, ROUNDUP(Total@row, -1))

This will add ten to any number in the TOTAL column where the rightmost digit is a zero.

Hope this helps!

~Andy B

Andy_B

Hi @Saj,

You were on the right track with the ROUNDUP function, but when you put a 10 after the Total@row, you are asking it to round to the nearest tenth decimal place (100.0000000000).

To round to the tens place (100.0) you need to use a negative one in your formula:

=ROUNDUP(Total@row, -1)

This will give the following result:

If you want the four rows with 100 to round up to 110, you can add the following modification to your formula:

=IF(RIGHT(Total@row, 1) = 0, ROUNDUP(Total@row, -1) + 10, ROUNDUP(Total@row, -1))

This will add ten to any number in the TOTAL column where the rightmost digit is a zero.

Hope this helps!

~Andy B

Saj

Hi ~Andy B,

Appreciate your response and second formula worked like a magic. 😃

Thank you so much.