Percentage formula for microsoft excel [Closed]

Report
-
 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
34
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3284 users have said thank you to us this month

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
Perfect answer thank you

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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
sorry it should be 140*1.2