Dumb Math: Remove 10% Discount

[MB11]

Hello

I have a list of WHSL prices with 10% discount. What formula can I run to get the original price?

The algebra would be x*.9=(cell value)

Thanks!

 

[jbeaucaire]

Simplest I can find is:

=A1*0.909091

...and to make the value absolutely the same:

=ROUND(A1*0.909091,2)

 

[MB11]

No, that just takes the discount further. I have the discounted price but I need the original price.

For example, if B2 has value $ 9.00 what formula can I run in A2 to get the results of $10.00?

 

[Sal Paradise]

To reverse X*.9 = Y, you'd want X = Y/.9

So =A1/.9 I'd assume.

 

[jbeaucaire]

Ah, I read that backwards, same idea:

=ROUND(A1*1.11111111,2)

Excel Workbook
	H	I	J
5	Value	10% Disc	Original Value
6	$ 10.00	$ 9.00	$ 10.00
Sheet1

 

[mikerickson]

DiscountPrice = .9 * OriginalPrice
OriginalPrice = DiscountPrice / .9

 

[MB11]

DiscountPrice = .9 * OriginalPrice
OriginalPrice = DiscountPrice / .9

That worked. Thanks!