Round Up to nearest 100 - Solution Found

liz.mayeux

I couldn't find my solution w/in these discussions, so I wanted to share my findings to help anyone that may need it.

I have a sum formula that can equal any number, but i need the final total to be to the closest 500.

6259 = 6500

825 = 1000

I tried to embed my roundup formula with little success and the help line suggested i create a 2nd column to provide the roundup formula. I discovered the mround formula instructions and though i would prefer to imbed the formula, i'm ok w/ this 2nd column idea.

Total Wearstrip formula

=SUM([WS in Helix & Return]@row:[WS in Inside HDR]@row)

TOTAL 9227.774

Total Wearstrip - Round Up formula

=IF([Total Wearstrip]@row > 0, MROUND([Total Wearstrip]@row + 500, 500), 0)

TOTAL 9500

I had to include the if statement, because the default result was showing 500, which is incorrect.

Paul Newcome

You could also do this without the helper column like so:

=IF(SUM([WS in Helix & Return]@row:[WS in Inside HDR]@row) > 0, MROUND(SUM([WS in Helix & Return]@row:[WS in Inside HDR]@row) + 500, 500), 0)

Paul Newcome

You could also do this without the helper column like so:

=IF(SUM([WS in Helix & Return]@row:[WS in Inside HDR]@row) > 0, MROUND(SUM([WS in Helix & Return]@row:[WS in Inside HDR]@row) + 500, 500), 0)

liz.mayeux

@Paul Newcome

That is great and thanks for helping me. Please be on the lookout for more questions from me! I have quite a few formula issues going on w/ my sheets these days.