Problem $1$ Part $3$: The owners want you to recalculate the amount charged from each

attendee based on the fact that new members must pay a joining fee of $$50,$ and that their

friends get a $25\%$ on the class cost.

That is$,$ just as before, a new member $($Y$)$ pays $$50,$ and a returning member $($N$)$ only pays

the class cost. However, attendees who are listed as friends of the owners $($Y$$ under Friend

Discount column$)$ get a $25\%$ discount on the class cost, based on their type $($Regular$,$ Student, or

Youth$).$ Use Nested IF Statements. Do not use the AND function.

$$ You should enter a formula in G$14,$ and then auto$-$fill the rest of the column.

$$ Make sure to use cell references, and not enter specific number in your formula.

$$ What$$s the total earned from all attendees? Place your answer in cell J$12.$

In the following problem, you will use Nested IF statements, Data Tables, and Scenario