Just learning Excel 2003. I have the discounted amounts and need to find the
dollar amount of the discount to get back to the original price. When I use
the help example of =A1/B1 (A1 is 15 B1 is 0.75) I get the correct answer.
Yet when I do the same formula with my numbers I get wrong calculations. For
example I used A1 20. discount in B1 0.25 and it gave me 100. and every other
entry I tried was calculated wrong. So simple yet I do not understand it.
--
moushia

Hi:

If 25 is the discount then:

=A1/(1-A2)

The original formula was was doing 15/0.75 ie 75%

if you want to get the discount try

=A1*A2/(1-A2)
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"moushia" wrote:

Just learning Excel 2003. I have the discounted amounts and need to find the
dollar amount of the discount to get back to the original price. When I use
the help example of =A1/B1 (A1 is 15 B1 is 0.75) I get the correct answer.
Yet when I do the same formula with my numbers I get wrong calculations. For
example I used A1 20. discount in B1 0.25 and it gave me 100. and every other
entry I tried was calculated wrong. So simple yet I do not understand it.
--
moushia

Thanks for the reply, I'm sure it is correct but it does not work for me.
Excel comes back with an error reply.
What I am trying to do is for example, if I bought a book that shows a
discount of 25% and the discounted price is 20.00 but it does not show what
the original price was, so I want the calculation to give me the dollar
amount representing the 25% discount that I will then add to the $20.00 to
come up with the original price.
--
moushia


"Martin Fishlock" wrote:

Hi:

If 25 is the discount then:

=A1/(1-A2)

The original formula was was doing 15/0.75 ie 75%

if you want to get the discount try

=A1*A2/(1-A2)
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"moushia" wrote:

Just learning Excel 2003. I have the discounted amounts and need to find the
dollar amount of the discount to get back to the original price. When I use
the help example of =A1/B1 (A1 is 15 B1 is 0.75) I get the correct answer.
Yet when I do the same formula with my numbers I get wrong calculations. For
example I used A1 20. discount in B1 0.25 and it gave me 100. and every other
entry I tried was calculated wrong. So simple yet I do not understand it.
--
moushia

Please disregard the previous reply. Just discovered what I was doing worng.
It is finally working. Many thanks.
--
moushia


"moushia" wrote:

Thanks for the reply, I'm sure it is correct but it does not work for me.
Excel comes back with an error reply.
What I am trying to do is for example, if I bought a book that shows a
discount of 25% and the discounted price is 20.00 but it does not show what
the original price was, so I want the calculation to give me the dollar
amount representing the 25% discount that I will then add to the $20.00 to
come up with the original price.
--
moushia


"Martin Fishlock" wrote:

Hi:

If 25 is the discount then:

=A1/(1-A2)

The original formula was was doing 15/0.75 ie 75%

if you want to get the discount try

=A1*A2/(1-A2)
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"moushia" wrote:

Just learning Excel 2003. I have the discounted amounts and need to find the
dollar amount of the discount to get back to the original price. When I use
the help example of =A1/B1 (A1 is 15 B1 is 0.75) I get the correct answer.
Yet when I do the same formula with my numbers I get wrong calculations. For
example I used A1 20. discount in B1 0.25 and it gave me 100. and every other
entry I tried was calculated wrong. So simple yet I do not understand it.
--
moushia