Someone please please help me with this formula on #5. I, for the life of me, can not figure this stuff out! I need help with the first 3 sentances of #5 and all of #7 I have attached a link to my workbook as a google doc, the format is Excel 2010 and here are the questions for the workbook I am having an issue with
5. Group the individual salesman worksheets and use the If function to calculate the commission for each month for each salesman. The commission is based on their sales for the month (refer to BonusPercentage worksheet). Use the user defined names that you created in #4 for the correct percentage. Format to currency with 2 decimals. Total the sales column and the commission column for each salesperson.</SPAN>
6. On the Summary worksheet create a Data Validation list that will only allow the names Sandra Adams, James Smith, Helen Jones, Fred Williams in cells A4-A7. Include an appropriate input message and an error alert message. Using the list to select each salesman’s name in the range A4:A7 so that all four salesmen are included.</SPAN>
7. On the Summary worksheet, use a formula to bring forward each salesperson’s total sales and total commission from their individual worksheets onto the Summary worksheet. (Do not need an IF, just bring forward the salesman’s total sales and total commission based on the salesman name in cells A4-A7.)
here is the link to the google doc workbook https://docs.google.com/spreadsheet/ccc?key=0AiuQ-78FGgY2dG1zWDVzdVNDQjRjY2I3ODRqLVRma1E
please please help me with these formulas!!!!</SPAN>
5. Group the individual salesman worksheets and use the If function to calculate the commission for each month for each salesman. The commission is based on their sales for the month (refer to BonusPercentage worksheet). Use the user defined names that you created in #4 for the correct percentage. Format to currency with 2 decimals. Total the sales column and the commission column for each salesperson.</SPAN>
6. On the Summary worksheet create a Data Validation list that will only allow the names Sandra Adams, James Smith, Helen Jones, Fred Williams in cells A4-A7. Include an appropriate input message and an error alert message. Using the list to select each salesman’s name in the range A4:A7 so that all four salesmen are included.</SPAN>
7. On the Summary worksheet, use a formula to bring forward each salesperson’s total sales and total commission from their individual worksheets onto the Summary worksheet. (Do not need an IF, just bring forward the salesman’s total sales and total commission based on the salesman name in cells A4-A7.)
here is the link to the google doc workbook https://docs.google.com/spreadsheet/ccc?key=0AiuQ-78FGgY2dG1zWDVzdVNDQjRjY2I3ODRqLVRma1E
please please help me with these formulas!!!!</SPAN>
