Thread: Calculations
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default 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