# Dumb Math: Remove 10% Discount

#### MB11

##### New Member
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!

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

#### jbeaucaire

##### Well-known Member
Simplest I can find is:

=A1*0.909091

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

=ROUND(A1*0.909091,2)

Last edited:

#### MB11

##### New Member
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?

##### Well-known Member
To reverse X*.9 = Y, you'd want X = Y/.9

So =A1/.9 I'd assume.

#### jbeaucaire

##### Well-known Member
Ah, I read that backwards, same idea:

=ROUND(A1*1.11111111,2)

Excel Workbook
HIJ
5Value10% DiscOriginal Value
6\$ 10.00\$ 9.00\$ 10.00
Sheet1

Last edited:

#### mikerickson

##### MrExcel MVP
DiscountPrice = .9 * OriginalPrice
OriginalPrice = DiscountPrice / .9

#### MB11

##### New Member
DiscountPrice = .9 * OriginalPrice
OriginalPrice = DiscountPrice / .9

That worked. Thanks!

Replies
5
Views
116
Replies
11
Views
204
Replies
6
Views
224
Replies
6
Views
137
Replies
4
Views
209

1,191,683
Messages
5,987,991
Members
440,124
Latest member
dippy_egg

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back