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 [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. Commission calculater.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Error : FileDialog
Hello, Could you please help me in attached excel file am getting error in diaFolder.Filters.Add "Excel", "*.xls", 1 line. Regards, Chandru -- 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. Book3.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Excel formula
Thank you, Vikas! On Tuesday, August 18, 2015 at 5:02:03 PM UTC-5, Mike B wrote: > > I would appreciate if someone would look at this formula and tell me what > I am doing incorrectly; I have a large spreadsheet called POS where I have > different variables separated and I am trying to use IF,AND,ISERROR in > nested IF statements and Excel doesn't like what I did. Please see my > formula below > > > '=IF(AND(ISERROR(VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),"n/a",VLOOKUP(A5388,POS!$A$2:$B$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),"n/a",VLOOKUP(A5388,POS!$H$5:$I$97,2,0)),IF(ISERROR(VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),"n/a",VLOOKUP(A5388,POS!$O$5:$P$97,2,0)),F(ISERROR(VLOOKUP(A5388,POS!$V$5:$W$97,2,0)),"n/a",VLOOKUP(A5388,POS!$V$5:$W$97,2,0)),F(ISERROR(VLOOKUP(A5388,POS!$AC$5:$AD$97,2,0)),"n/a",VLOOKUP(A5388,POS!$AC$5:$AD$97,2,0))) > > Thank you for any help you can give, > > MikeB > -- 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.
$$Excel-Macros$$ Client in Lincolinshire, IL need OBIEE Developer with Informatica
Hi Partner, Hope you are doing great… Please send resume to ma...@genuineitllc.com *OBIEE Developer with Informatica * *Lincolnshire, IL* *12 months* *Job Details* This person will be a key member of the OBI Apps Development Team. You will contribute to full life cycle implementations. *Mandatory Skills* ü -5 – 7 years of hands-on experience on OBI Apps (10 g / 11g) ü -Should have worked on at least 2 - 3 end to end implementations (Analysis; ETL; RPD; Reports and Dashboards) --Excellent knowledge on below skill set is MUST. ü *Informatica 8.x / 9.x – PowerCenter Designer* ü *Workflow Manager* ü *Workflow Monitor DAC (10g / 11g) RPD (10g / 11g)* ü *Reports and Dashboards (10g / 11g)* ü Oracle SQL ü PL/SQL ü Good understanding of *Siebel* applications ü Exceptional troubleshooting skills ü Good communication skills --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as "Spam" as we have included the contact information. If you wish to be removed from our mailing list, please respond with "remove" in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- 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.
$$Excel-Macros$$ Client in Houston TX need Supply Chain Management SAP APO PPDS Functional Consultant
Hi Partner, Hope you are doing great… Please send resume to ma...@genuineitllc.com *Supply Chain Management SAP APO PPDS Functional Consultant* *This is in Houston* Looking for 8 plus years of general SAP Really want strong PP/DS Full SDLC is required Wants someone with both hands on and architecture experience within this module Chemical process knowledge from a supply and demand aspect Chemical vertical experience is required 12 months cth, but can be h1b He wants NA project experience he has seen mostly international candidates *Supply Chain Management SAP APO PPDS Functional Consultant* *Position summary:* Within the Global IT Application - Supply Chain Group we are currently looking for a functional consultant who will actively participate in various business requirement gathering, solution designing and implementing the solution in the area of production planning and detailed scheduling module and global ATP module from APO. *Performance objectives:* - *Participation in Business Requirement Sessions*: - Able to engage business in the discussions which would lead to complete the business requirement / information. - *Solution Design*: - With your strong SAP APO PPDS experience you should be able to provide best fit solution to design production planning and scheduling process. The solution should be based mostly as per standard PPDS functions available. However customizing to fulfill the needs of the business should be also explored. You should be aware GATP functionalities and have done implementation for allocation, availability. You should be also aware of multilevel ATP design. - *Implementation of Solution*:- Should be able to build the solution in the system, capable of performing testing by create relevant data, so that business user gets to test error free system design or with minimal error. - *Project Timelines*: - You should be able to work on the agreed timelines and give honest effort to ensure the project deliverables are met within time. *Required key skills (MUST have):* - SAP APO Production Planning & Detail Scheduling , functional expertise (5 + years) - Production Planning Functions in APO - Detail Scheduling Functions in APO - Block Planning Functions and Setup Matrix Function, alternative resource selections of PPDS - Extensive knowledge of PP/DS Planning Board - Very good knowledge resource master data in APO - Core Interface Knowledge for relevant master data / transactional data setup - Very good understanding of PDS, operation, activities, mode - Excellent in identifying co-relation between different time horizons (like PP/DS horizon, Planning Time Fence etc.) - Ability to control master data requirement such that there is minimal maintenance required in SCM system by the business after the implementation. - Ability to provide apt solution based on business requirement for defining correct planning cycle. - Must understand the concept of consumptions of forecast. - Must have basic understanding of ABAP (debugging, identifying right exits, badi’s etc.) - SAP APO Global ATP , functional expertise (5 + years) - Allocation Management - Availability Check - Must be aware of related SD setting - Have experience in Multi level ATP - SAP Production Planning, functional expertise (5 + years) - Must be able to understand Material Requirement Planning concept of ECC - Must be able to work with MRP along with planning or scheduling in APO system. - Very good understanding of mater data MRP views in Material Master, Work Center, Resource, Recipes, and Production Version etc. Consulting skills: - Communication & Teaming - In time issue resolution - Process Industry expertise (minimum 6 years) - Language skills: fluent in English; Key Skill Set (Nice to Have):- - Knowledge of SD - Knowledge of APO DP. --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as "Spam" as we have included the contact information. If you wish to be removed from our mailing list, please respond with "remove" in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- 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 offici
$$Excel-Macros$$ Client in Foster City, CA need Sr. Java Engineer inperson Interview MUST
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title: Sr. Java Engineer Location: Foster City, CA Duration: 6 months, then extension up to 2 years Interview Process: Phone, then onsite * *Must have skills:* -At least 7 years of relevant experience -Experience with designing and developing -Good experience working with databases and designing schemes of databases -Experience with Web Server applications. -Experts with JDK 1.5 or later and have multi-year experience working on Java Spring, Hibernate, RESTful services *Nice to have skills:* -Tomcat -Chef -Splunk -Python -PowerShell -PowerCLI -Good experience with Java developing *Preference on industry background or previous companies worked for:* -Background with cloud computing is a plus *Description:* Cybersource TestLab team is looking for engineers who are passionate about DevOps and a mindset for enabling this culture. The effort primarily involves workflow automation that requires integrating with services using with SOAP or REST. The candidate will be responsible for adding new features and enhancing services we are building that integrate Cloud providers, our ticketing system and services provided by other teams. We are looking for ways to eliminate wait times, manual handoffs and automating everything that is possible and improve the overall efficiency of our processes. *Education/Experience:* Bachelor's degree in computer science, software engineering or relevant field required 7-8 years' experience required in skillsets mentioned below *Mandatory Skills:* Well versed with Object Oriented Concepts Extensive experience using Java Design Patterns Expert with JDK 1.5 or later Multi-year experience working on Java Spring, Hibernate, RESTful services In-depth knowledge and hands-on with multi-threading and concurrency concepts. Experience with Caching and other optimization techniques. Hands-on with PL-SQL and comfortable writing complex queries Comfortable working on both Windows and Unix environments. Must have extensive experience working with Web Server preferably Tomcat. Sound knowledge and experience working in Agile model. Experience writing shell scripts. Good understanding of networking and virtualization concepts. Exceptional troubleshooting and analytical skills *Highly Desired Skills:* Working experience in cloud computing, PaaS, IaaS and related areas. *Fair or better experience in following:* o Chef o Splunk o Python o PowerShell o PowerCLI *Any front-end development experience with:* o HTML5 o CSS3 o Native Javascript o JQuery --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… [image: cid:image001.png@01CD0B34.DFB7EBF0] Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects [image: cid:image004.png@01CDB5D0.74A7EE40] According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as "Spam" as we have included the contact information. If you wish to be removed from our mailing list, please respond with "remove" in the subject field. We apologize for any inconvenience caused. [image: Description: stylepic_globe1]Please consider the environment before printing this e-mail -- 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.
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 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
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 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 > 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,