# rounding error

#### winde

##### New Member
Hi, i'm facing an issue with rounding error and i would like to know if there is a way to solve it.
below is an simple example.

 quantity a b c d 50 35% 21% 16% 28% using int formula 17 10 8 14 49 using round formula 18 11 8 14 50

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col span="3" style="text-align: center;"></colgroup><tbody>
</tbody>

but technically, 18+11+8+14=51

so how can i get exact 50 quantity?

Thanks.

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Round just does that, up or down by the result, finacial rounding is even more erractic. The results you are getting are what really happens. Just looking at the values 18 is half of 36 and 11 half of 22

Last edited:
There is no way to solve what you have there. The only way for the numbers to total the 50 is if you dont round them. Rounding can produce totals that differ slightly than the original total. You could format them to look like integers whilst retaining their underlying value. All depends what you are using it for.

Replies
0
Views
460
Replies
0
Views
257
Replies
2
Views
114
Replies
2
Views
42
Replies
1
Views
138

1,203,460
Messages
6,055,557
Members
444,797
Latest member
18ecooley

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back