Trouble with simple percentage formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

moushia - 27 Feb 2007 23:07 GMT

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.

Signature

moushia

Reply to this Message

Martin Fishlock - 28 Feb 2007 00:06 GMT

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)

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> 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.

Reply to this Message

moushia - 28 Feb 2007 01:48 GMT

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.

Signature

moushia

> Hi:
>
[quoted text clipped - 14 lines]
> > 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.

Reply to this Message

moushia - 28 Feb 2007 01:56 GMT

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

Signature

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.
[quoted text clipped - 22 lines]
> > > 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.

Reply to this Message