Multiplication Error

A

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
 
J

JulieD

Hi

=round((A1*0.5)*0.9*0.95,2)

where A1 contains the retail price

hope this helps
Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top