I$\text{'}$m getting a #NAME? error in cells C$15$:C$17,$ and then in C$20,$ and D$20$

PHRE $=\_$xlfn$.$IFS$($C$12<=$C$7,$C$14*$D$7,$C$12<=$C$8,$C$14*$D$8,$C$12<=$C$9,$C$14*$D$9,$C$12>=$B$10,$C$14*$D$10$

Fee Calculation $=\_$xlfn$.$IFS$($C$12<=$C$7,$C$15*$E$7,$C$12<=$C$8,$C$15*$E$8,$C$12<=$C$9,$C$15*$E$9,$C$12>=$B$10,$C$15*$E$10$

These were input for me$,$ but they are causing big errors.

SelectThe cell C$14$ on the Calculator worksheet. The total commission is calculated by multiplying the selling price by the commission rate.

Select cell C$15.$ The IFS function checks the selling price $($C$12)$ to determine the split percentage $($column D$)$ based on the price group.

Select cell C$16.$ The IFS function checks the selling price $($C$12)$ to determine the administrative fee percentage $($column E$)$ and multiplies that percentage by the value in cell C$15$ to calculate the fee in dollars.

Select cell C$17.$ The net commission is calculated by subtracting the fees from the PHRE amount.

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.

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.

Use Solver to find target PHRE net commission amounts.

Build a Solver problem with cell C$17$ as the objective cell. For the first solution, set the objective to a value of $50000$ by changing cell C$12.$ Use the GRG Nonlinear solving method. Save the results as a scenario named $$50,000.$

Restore the original values and run another Solver problem to find a selling price for a PHRE commission of $75000.$ Save these results as a scenario named $$75,000.$

Restore the original values and run a third Solver problem to find a selling price for a net commission of $$100,000.$ Save these results as a scenario and restore the original values.

Manage scenarios.

Show the $$50,000$ scenario in the worksheet.

Create a Scenario summary report for cells C$12,$ C$14,$ and C$17.$

Create a histogram for recent sales.

Click the Sales Forecast sheet tab and select cell G$13.$

Create a bin range of $10$ values starting at $350,000$ with intervals of $50,000,$ ending at $800,000$ in cell G$22.$

Use the Analysis ToolPak to create a histogram for cells E$5$:E$26.$ Do not check the Labels box and select the bin range in your worksheet.

Select cell H$3$ for the Output Range and include a chart.

Position and size the chart from cell K$3$ to cell V$19.$

Edit the horizontal axis title to display Selling Price and edit the vertical axis title to Number of Sales.

Edit the chart title to display Sales by Price Group.

Select and delete the legend.

Clear the contents in cells G$13$:G$22($Figure $9-88).$

The bins are at $50,000$ intervals.