Building a commission sheet end to end

Was du danach kannst

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.

Schritt 1 von 7 · 1 Punkt

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.