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
|