Thread: Calculations
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default 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