See how to calculate commission on sales when there is more than one level of commission incentive pay. See how to make the lookup table smartly to reduce formula size. See how to use 3 VLOOKUP functions in one formula, including looking up values in the 1st, 2nd and 3rd columns. See how to do the same formula with LOOKUP function to reduce formula size and formula creation time.
Excel Magic Trick 452
Commission Bracket tables are similar to Tax Bracket Tables.