Building a commission sheet end to end

What you will be able to do

Combine lookup, conditional aggregation and banded rates into one commission calculation that survives new data.

Four reps, a tier table, 314 orders. Everything in this course, on one sheet, producing a number somebody gets paid. This is where it stops being exercises.

Step 1 of 7 · 1 point

On a new sheet with the four rep names in A4:A7, total each rep's sales. Write the formula for B4, so that it copies down.