$1.$ 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.

$2.$ Name cell ranges.

Click the Price Solver worksheet tab.

Click cell C$12$ and name the range Selling$\_$Price. You cannot use spaces in a range name.

Name cell C$14$ as Total$\_$Commission and cell C$17$ as PHRE$\_$Commission.

Install the Solver Add$-$in and the Analysis ToolPak.

I need help on what to put in the column input for the data table with D$8,$ I just need a step by step tutorial on how to do the formulas. A picture with data will be provided.

A

B

C

D

E

F

G

$1$

$2$

Placer Hills

Commission Split

Calculator

$\backslash$table$[[$Price Group,,$\backslash$table$[[$imum$],[$ice$]],,\backslash$table$[[$Maximum$],[$Price$]],$Current Splits,$\backslash$table$[[$Estimated$],[$Fees$]]],[1,$$$,-,$$$,1,499,999,50\%,2\mathrm{.}5\%],[2,$$$,1,500,000,$$$,5,499,999,50\%,3\mathrm{.}0\%],[3,$$$,5,500,000,$$$,9,499,999,45\%,3\mathrm{.}0\%],[-4,$$$,9,500,000,$$$,13,499,999,45\%,3\mathrm{.}0\%]]$

$\backslash$table$[[$Selling Price,$$,2,750,000],[$Commission Rate,,$6\%],[$Total Commission,$$,165,000],[$PHRE$,$$$,82,500],[$Fee Calculation,$$,2,475],[$Net Commission,$$,80,025]]$

$\backslash$table$[[$Proposed Split,Before Fees,After Fees$],[,$$$82,500\mathrm{.}00,80,025\mathrm{.}00],[30\%,,],[35\%,,],[40\%,,],[45\%,,],[50\%,,],[55\%,,],[60\%,,],[65\%,,]]$