E eabwhat13 New Member Nov 28, 2012 #1 I am looking to put together a sales comission chart for a tiered sales structure [pre] Code: 0 - 3,000 = 3% 3001 - 6000 = 5% 6001 - 10,000 = 8% 10,001+ = 12% [/pre] Can someone help me with the formula for this?
I am looking to put together a sales comission chart for a tiered sales structure [pre] Code: 0 - 3,000 = 3% 3001 - 6000 = 5% 6001 - 10,000 = 8% 10,001+ = 12% [/pre] Can someone help me with the formula for this?
Faseeh Excel Ninja Nov 28, 2012 #2 Hi eabwhat13, Welcome to the Forums!!! When posting sample data, enclose it in backticks (`), this will made reading and indentation easier. You can use VLOOKUP(), if your data in A1:B4, this will work: Code: =VLOOKUP(D1,A1:C4,3) ...D1 contains lookup value. Regards,
Hi eabwhat13, Welcome to the Forums!!! When posting sample data, enclose it in backticks (`), this will made reading and indentation easier. You can use VLOOKUP(), if your data in A1:B4, this will work: Code: =VLOOKUP(D1,A1:C4,3) ...D1 contains lookup value. Regards,
T Trader273 New Member Nov 28, 2012 #3 Something like this seems perfect in using the Select Case method in VBA.
