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