Bands in excel exercise

Free Preview

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 %)

Video Instructions

To follow along go to 5_3_1

Video Solution

To follow along go to 5_3_2

Back to: Free VLOOKUP Course > VLOOKUP Approximate Match