Related:

- Percentage formula for microsoft excel
- Excel marksheet percentage formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Microsoft excel download - Download - Spreadsheets
- Logitech formula vibration feedback wheel driver - Download - Drivers

## 3 responses

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

in the cell I41 type the formula

=I40-1.2

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.

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
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Jan 31, 2011 at 09:44 PM

Jan 31, 2011 at 09:44 PM

sorry it should be 140*1.2

Jan 31, 2011 at 10:39 AM

Nov 8, 2011 at 11:38 AM

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

Jan 5, 2012 at 06:17 AM