Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Step' or Matrix Calculations
Here it goes.
Sales % 0-$250,000 0 $250,001-$500,000 15 $500,001-$1,000,000 20 $1,000,001-$2,000,000 25 $2,000,001-$3,000000 30 So I cant figure out the formula that would give me my desired result as illustrated as follows. If a person sells between 0 and $250k, then don't apply a percentage, but if that person sells $750k: dont apply a percentage on the first $250k in sales, 15% on the amount between $250,001 and $500,000 and finally 20% on all sales above $500,001. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Step' or Matrix Calculations
This link explains how to do it:
http://www.mcgimpsey.com/excel/variablerate.html Hope this helps. Pete On Dec 24, 12:04*am, RBG wrote: Here it goes. Sales * * * * * * * * * * * * * * * * *% 0-$250,000 * * * * * * * * * * * * * 0 $250,001-$500,000 * * * * * * * 15 $500,001-$1,000,000 * * * * * *20 $1,000,001-$2,000,000 * * * * 25 $2,000,001-$3,000000 * * * * *30 So I cant figure out the formula that would give me my desired result as illustrated as follows. *If a person sells between 0 and $250k, then don't apply a percentage, but if that person sells $750k: dont apply a percentage on the first $250k in sales, 15% on the amount between $250,001 and $500,000 and finally 20% on all sales above $500,001. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need step by step to add invoice numbering to excel template | New Users to Excel | |||
Multiple Matrix calculations from data list | Excel Discussion (Misc queries) | |||
matrix calculations | Excel Worksheet Functions | |||
What is the step-by-step procedure for making a data list? | Excel Discussion (Misc queries) | |||
I need step by step instructions to create a macro for 10 imbedde. | Excel Worksheet Functions |