# Percentage formula for microsoft excel

Closed
Dougie - Jun 25, 2009 at 03:25 PM
KEGS - Jan 5, 2012 at 06:17 AM
Hello,
Im looking for help regarding a pricing sheet im trying to create on excel.I have my list of costs ok where im adding the totals in the cells ,my cost total is in cell I40 and in I41 im trying to add a 20% mark up figure of the total in I40 can anyone help

## 3 replies

I presume what you mean by 20% mark up figure is 20% more of the value in the cell I40

in the cell I41 type the formula
=I40-1.2
This did not work
A2 = Purchase Price
B2 = Markup Percentage
C2 =A2/(1-(B2/100)) (Sale Price)
Test your results: Sale - Markup Percentage = Purchase Price
Example: An item purchased for \$100 and marked up 50% = \$200, not \$150.
\$200 - 50% = \$100
May 4, 2010 at 03:04 AM
Type I :

5000=10%, 10000=12.5%, 20000=15%, 40000=17.5%, 70000=20%, 115000=22.5%, 170000=25%, 260000=27.5%, 350000=30%

Type II :

2499=0%, 2500=1%, 5000=2%, 10000=3%, 20000=4%, 40000=5%, 80000=6%, 160000=7%, 250000=8.5%, 350000=10%.

Above two formulas in different columns.
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Jan 31, 2011 at 09:44 PM
sorry it should be 140*1.2