The second argument is also referring to the table from which to pull the commission rate.The first argument referred to the cell that contains the value to look for.The example below shows a worksheet that uses the VLOOKUP function to determine the commission a sales rep gets, based on how much sales she makes. The commission can be set on flat rate, which is usually a percentage, say 7 percent, on any sales the representative makes.īusinesses can also use progressive commission, where the percentage of commission rises as sales rep hit certain targets.įor example, selling $10,000 worth of goods or services can earn the representative 10 percent commission, a 15 percent commission on the next $10,000, and so on. The more sales they make, the more commission they earn, and the more money the company makes too. The commission of such workers is often calculated as a percentage of the sales they made. Many sales jobs pay workers on a commission basis. VLOOKUP EXAMPLE 10: Partial text match with wildcard. EXAMPLE 9: VLOOKUP from another Workbook.EXAMPLE 3: Return products and prices using ID.VLOOKUP EXAMPLE 2: Income Tax rate Calculator.VLOOKUP EXAMPLE 1: Commission Calculator.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |