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 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 a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/Oc6DPekl5Nk/unsubscribe. > To unsubscribe from this group and all its topics, 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 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.
