Calculations
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...
"Dig" wrote:
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
|