In the file you downloaded look for the sheet name ‘VLOOKUP-Bands-1’
In this example we have a situation where different levels of sales result in different commission rates. Calculate the commission % allowed and the commission earned
- In B13 to B17, determine the commission % that applies to the sales generated in column A based on the table in C7 to D11.
- In C13 to C17 calculate the commission earned (i.e. Sales times the commission %)
To follow along go to 5_3_1
To follow along go to 5_3_2