rounding error

[winde]

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.

 

[mole999]

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

 

[steve the fish]

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.