How do I find the original price?

S

SRedford

If I have the discounted price and the discount percentage that that price
represents, what formula do I use to find out what the original price is?

For example:

The discounted price is $24.23
The discount percentage-from-list that $24.23 represents is 51%
What is the list price?

Thanks!
 
S

Sheeloo

original price = discounted price/ discount rate

in the case cited by you original price would be 24.23/0.51 which is 47.51.
You will have to take care of rounding errors.
 
P

Peo Sjoblom

=24.23/(1-51%)

or expressed in decimals

=24.23/(1-0.51)

returns

49.44898

which would be

$49.45

using dollars and cents

--


Regards,


Peo Sjoblom
 
P

Peo Sjoblom

That's not correct

Original price = discounted price / (1-discount rate)


--


Regards,


Peo Sjoblom
 

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

Similar Threads

Calculations 2
calculate percentage?? 2
Conditional PRODUCT or SUM 9
In a sales quote sheet - sum totals by license type 1
Excel - can one value be automatically substituted for another? 1
Percentage Discount 3
Multiplication Error 3
percent and dollar formula don't mix 2

Top