Hi Sylvain,
It looks like the solution is with the rounding of the amounts.
round((172.64/1.075), 2) = 160.59
round((160.59/1.07), 2) = 150.08
>Because of the roundings, you may not get the exact original price with this calculation.
>
>Ex.:
Original price: 150.08$
>T.P.S.: 10.5056$ (rounded to 10.51$)
>T.V.Q.: 12.04425$ (rounded <B>up</B> to 12.05$)
>Total: 172.64$
>(172.64/1.075)/1.07 = 150.08911$ (rounded to 150.09$)
You may want to recalculate the taxes to validate the amount and adjust it if necessary.
>
>HTH
>
>>If you know each of the tax percentages, just divide them from the total price.
>>
>>you had:
>>((150*1.07)*1.075)= 172.54
>>
>>To get the original price ($150), just divide the taxes from the total:
>>((172.54/1.075)/1.07)=150
*******************************************************
Save a tree, eat a beaver.
Denis Chassé