# Percentage formula for microsoft excel

Closed
-
KEGS -
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
Related:

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

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.
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
sorry it should be 140*1.2