Several cells needing multiplied

[ajpowers]

I am trying to compute an ending sales price after several discount
have been applied. We have a retail price that is discounted multipl
times depending on the type of customer we are dealing with.

For example:

Retail Price = $2.95
Dealer Discount = 50% then 10% then 5%
Dealer Price = $1.26

The sum of the first discount is then multiplied by the next discount
and so on. What formula can I use to compute the following?

2.95 * .50=1.48
1.48*.10=.15
1.48-.15=1.33
1.33*.05=.07
1.33-.07=1.2

 

[Ken Wright]

One way that might be easy to understand is as follows:-

=2.95*(1-50%)*(1-10%)*(1-5%)

The %s and numbers can be replaced with cell references, eg with the 2.95 in
cell A1, and your %s in C1,C2,C3 respectively

=A1*(1-C1)*(1-C2)*(1-C3)