Direct Formula
=2*100*(2-5%*(1+2%)) = 389.8
=2*100-(2*100*5%)+(2*100-(2*100*5%)*2%) = 389.8
Regards,
Stefi
€˛Rechie€¯ ezt Ć*rta:
What is the formula for below equation?
Qty Order=2
Unit Price=USD 100
Discount=5% (less)
Freight Chrgs=2% (add)
Net Amount=?
In single range I type, =2*100-(2*100*5%)+(2*100-(2*100*5%)*2%)
Can you simplify this formula?
Thanks.
Rechie
|