Round into a Total Number

[Johanna1789]

I have these figures below, that I need to round up to the next or last $50 dollars. The problem is I need the total of all the ROUNDED figures to equal $100,000. Any help is appreciated.

$10,204​

$5,102​

$4,082​

$1,020​

$12,755​

$2,041​

$9,694​

$9,184​

$3,571​

Total = $100,000​

 

[Joe4]

Welcome to the Board!

That is going to be very difficult, as when you have more than two values that you are rounding, you might not get the results you want,

For example, let's say that we have the following three values adding up to 1,000:
233
333
434

If you round each one to the nearest 50, you get:
250
350
450
which adds up to 1,050.

That is just the nature of the beast when rounding multiple numbers, but then wanting the sum to add up to a particular number. It could be more (like in this case, or it could be less).

What I have seen done sometimes is people will round every number, except for the last one.
And then with the last one, they will simply take the sum of all the other rounded numbers, and subtract from the desired result.
So in our example, you would end up with:
250
350
400
since the last number would be:
1,000 - (250 + 350) = 400

 

[Johanna1789]

ooo thank you for the quick response. I like your suggested approach.

 

[Joe4]

You are welcome!
Glad I was able to help.