View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo Sheeloo is offline
external usenet poster
 
Posts: 793
Default How do I find the original price?

You are right. Sorry for the mistake.

"Peo Sjoblom" wrote:

That's not correct

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


--


Regards,


Peo Sjoblom

"Sheeloo" wrote in message
...
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.
"SRedford" wrote:

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!




 
ExcelBanter Database Error
Database Error Database error
The ExcelBanter database has encountered a problem.

Please try the following:
  • Load the page again by clicking the Refresh button in your web browser.
  • Open the www.excelbanter.com home page, then try to open another page.
  • Click the Back button to try another link.
The www.excelbanter.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.