Build one$-$variable data tables.

Select cell C$20$ and create a reference to cell C$15.$

Select cell D$20$ and create a reference to cell C$17.$ Both formulas depend on cell C$12,$ the one variable.

Use cell D$8$ as the column input for the data table $($Figure $9-87).($You can use any percentage from column D because its value is replaced by the proposed rates in column B in the data table.$)$

You can use any cell in column D as the input cell.

Figure $9-87$ Data table setup for commission rates

Decrease the decimal two times for all values in the data table.