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

Word VBA - Automatic change content of a cell in table using dropdown list 5
Calculations 2
Mail Merge Directory Conditional Page Break 0
Formula re value in column C or D, calculations made on either in column E? 8
Consolidation Table from Different Excel Tabs with Different Format 1
calculate percentage?? 2
Conditional PRODUCT or SUM 9
PERCENTAGES 3

Top