| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find the original price?
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find the original price?
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find the original price?
=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 "SRedford" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I find the original price?
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| find an original worksheet file before changes were made | Excel Worksheet Functions | |||
| How do I make a spreadsheet w/ original price and then %? | Excel Worksheet Functions | |||
| find selling price of bonds | Excel Worksheet Functions | |||
| Auto save replaced my original file and now I need the original? | Excel Discussion (Misc queries) | |||
Linear Mode
