Hi guys, hope you can help me. I have a series of numbers where I am rounding that number by the nearest 9. The round function works nicely however when I add these numbers up, it does not equal the total I am seeking. Here are the numbers:
24.13408 Round Number 27
108.6034 Round Number 108
144.8045 Round Number 144
30.1676 Round Number 27
108.6034 Round Number 108
156.8715 Round Number 153
156.8715 Round Number 153
108.6034 Round Number 108
120.6704 Round Number 117
108.6034 Round Number 108
12.06704 Round Number 9
Now when I add the round numbers, it totals 1062. I need to this add up to 1080. The difference is 18 so I essentially have 2 9s to be distributed so that it equals 1080. Is there a way to do this? Thanks in advance!
24.13408 Round Number 27
108.6034 Round Number 108
144.8045 Round Number 144
30.1676 Round Number 27
108.6034 Round Number 108
156.8715 Round Number 153
156.8715 Round Number 153
108.6034 Round Number 108
120.6704 Round Number 117
108.6034 Round Number 108
12.06704 Round Number 9
Now when I add the round numbers, it totals 1062. I need to this add up to 1080. The difference is 18 so I essentially have 2 9s to be distributed so that it equals 1080. Is there a way to do this? Thanks in advance!