It's working, Thanks!

"smartin" wrote:

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

From the ground-up I would think it's

Net=Qty*UnitPrice*(1-Discount)*(1+Freight)

I'm too lazy to see if your formula simplifies to the same.
.