On Sep 18, 9:18 am, Rayasiom <Rayas...@discussions.microsoft.com>
wrote:
> Invoice Amount: ( 10,000.00)
> Less Fee: x
[quoted text clipped - 8 lines]
>
> I need help in creating a formula for the x Fee
Start at the end and work backwards.
z = round( 82%*(invoice amount) - (net salary), 2)
y = round( z/(1-5%), 2)
x = (invoice amount) - insurance - (gross pay) - y
5% fees on y is best computed as y-z to minimize rounding error. But
as a check, you might compute 5%*y on the side.
Also as a check, you might compute (invoice amount)-fee(x)-insurance-
(gross pay) on the side.
Rayasiom - 19 Sep 2007 10:00 GMT
Genius!!
> On Sep 18, 9:18 am, Rayasiom <Rayas...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 24 lines]
> Also as a check, you might compute (invoice amount)-fee(x)-insurance-
> (gross pay) on the side.