View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default 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!