Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved
See this for simple formula solution. Lear More@ www.ExcelVbaLab.Com On Thursday, August 20, 2015 at 12:02:41 PM UTC+5:30, Ashok Soni wrote: Dear Pankaj Sharma, thanks of lot, i will make it on other sheet. i had sent it ( incentive slab for example to understand what i am looking ) your formula is best way for me, if i need more help regarding this i will disturb you again. thanks again On Thu, Aug 20, 2015 at 10:56 AM, Pankaj Sharma pankaj...@gmail.com javascript: wrote: Dear Ashok, I don't think there is any easiest way to calculate this with excel formula's. You can do with run a macro or better if you make a slab chart on the right side or other sheet to calculate the same. This will be easy if you have to change slab criteria in future. On Wed, Aug 19, 2015 at 3:03 PM, Ashok Soni soni.as...@gmail.com javascript: wrote: Dear Rajan Sir, I need a formula in excel which can calculate commission on target amount. i describe as bellow: 1. suppose i have 10 branches and more than 3 employee in each. 2. i have different % slab of commission. 3. commission should be calculate stab by stab. i have explain it in excel file, if you think it is not explain properly please provide your contact no. i will call you. i have attached of excel file. please help me On Monday, September 10, 2012 at 7:23:40 PM UTC+5:30, Rajan Verma wrote: *See the attached* *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are
Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved
Dear Pankaj Sharma, thanks of lot, i will make it on other sheet. i had sent it ( incentive slab for example to understand what i am looking ) your formula is best way for me, if i need more help regarding this i will disturb you again. thanks again On Thu, Aug 20, 2015 at 10:56 AM, Pankaj Sharma pankaj123...@gmail.com wrote: Dear Ashok, I don't think there is any easiest way to calculate this with excel formula's. You can do with run a macro or better if you make a slab chart on the right side or other sheet to calculate the same. This will be easy if you have to change slab criteria in future. On Wed, Aug 19, 2015 at 3:03 PM, Ashok Soni soni.ashok1...@gmail.com wrote: Dear Rajan Sir, I need a formula in excel which can calculate commission on target amount. i describe as bellow: 1. suppose i have 10 branches and more than 3 employee in each. 2. i have different % slab of commission. 3. commission should be calculate stab by stab. i have explain it in excel file, if you think it is not explain properly please provide your contact no. i will call you. i have attached of excel file. please help me On Monday, September 10, 2012 at 7:23:40 PM UTC+5:30, Rajan Verma wrote: *See the attached* *Regards* *Rajan verma* *+91 7838100659 %2B91%207838100659 [IM-Gtalk]* *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like
Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved
Dear Ashok, I don't think there is any easiest way to calculate this with excel formula's. You can do with run a macro or better if you make a slab chart on the right side or other sheet to calculate the same. This will be easy if you have to change slab criteria in future. On Wed, Aug 19, 2015 at 3:03 PM, Ashok Soni soni.ashok1...@gmail.com wrote: Dear Rajan Sir, I need a formula in excel which can calculate commission on target amount. i describe as bellow: 1. suppose i have 10 branches and more than 3 employee in each. 2. i have different % slab of commission. 3. commission should be calculate stab by stab. i have explain it in excel file, if you think it is not explain properly please provide your contact no. i will call you. i have attached of excel file. please help me On Monday, September 10, 2012 at 7:23:40 PM UTC+5:30, Rajan Verma wrote: *See the attached* *Regards* *Rajan verma* *+91 7838100659 %2B91%207838100659 [IM-Gtalk]* *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@googlegroups.com. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting
Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved
Dear Rajan Sir, I need a formula in excel which can calculate commission on target amount. i describe as bellow: 1. suppose i have 10 branches and more than 3 employee in each. 2. i have different % slab of commission. 3. commission should be calculate stab by stab. i have explain it in excel file, if you think it is not explain properly please provide your contact no. i will call you. i have attached of excel file. please help me On Monday, September 10, 2012 at 7:23:40 PM UTC+5:30, Rajan Verma wrote: *See the attached* *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *Rashid Khan *Sent:* 10 September 2012 1:20 *To:* excel-macros *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.com javascript:. To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Commission calculater.xlsx Description: MS-Excel 2007 spreadsheet
RE: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved
See the attached Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rashid Khan Sent: 10 September 2012 1:20 To: excel-macros Subject: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Copy of Commission-Excel Group.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
