On Thu, 15 Oct 2009 08:54:14 -0700, Rechie
wrote:

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


=Qty*Unit_Price*(1-Discount+Freight)

or, in your terms

=2*100*(1-5%+2%)

--ron