Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations
A1 is list price, A2 is first discount, A3 is second discount. New price is:
=a1*(1-a2)*(1-a3) Regards, Fred. "Dig" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then Calculations | Excel Worksheet Functions | |||
IRR Calculations | Excel Discussion (Misc queries) | |||
Calculations seem to be off... | Excel Discussion (Misc queries) | |||
Help with PV calculations | Excel Worksheet Functions | |||
Calculations | Setting up and Configuration of Excel |