Direct Formula
 

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

Direct Formula
 

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.

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

Direct Formula
 

Hi Stefi,

Thanks, but if I will compute it manually the results is different:

2*100 =200
Discount 5% = 10 (less)
Freight Chrgs 2% = 4 (add)
---------
Net Amount = 194



"Stefi" wrote:

=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

Direct Formula
 

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

Direct Formula
 

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.
.

Direct Formula
 

It's working, thanks!

"Ron Rosenfeld" wrote:

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
.

Direct Formula
 

It's interesting that you say "It's working, thanks!" in response to this
formula, but also in response to the alternative suggestion, which is
effectively
=2*100*(1-5%)*(1+2%)

They give different answers, so you'll have to decide which you want, but
the latter would be more usual.

Your formula, of course, gave a totally different answer, of the order of
twice the correct answer, so congratulations if you can persuade your
customers to pay that much. :-)
--
David Biddulph

"Rechie" wrote in message
...
It's working, thanks!

"Ron Rosenfeld" wrote:

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
.