Calculations

[Dig]

I need to calc a discount and second discount as follows
List price 799
Discount 50%
add discount 5%

The additional discount must be off of the discounted list price. The
Discount and additional discount number may change so I need a formula that
will all me to change the numbers.

Any help appreciated
Thanks

 

[Sheeloo]

If List Price is in A1
Discount in B1 and
Additional Discount C1

Then
=A1*B1 will give you original discount
=A1*B1 + A1*B1*C1 will give you both added together which is same as
=A1*B1*(1+C1)

It is assumed B1 and C1 are in percentages... if B1 is 50 and C1 is 5 then
you have to divide by 100...

 

[Fred Smith]

A1 is list price, A2 is first discount, A3 is second discount. New price is:
=a1*(1-a2)*(1-a3)

Regards,
Fred.