Related:
- Excel marksheet percentage formula
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
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 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
31 Jan 2011 à 21:44
31 Jan 2011 à 21:44
sorry it should be 140*1.2
31 Jan 2011 à 10:39
8 Nov 2011 à 11:38
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
5 Jan 2012 à 06:17