Related:
- Percentage formula for microsoft excel
- Excel marksheet percentage formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - 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