What is the Amount Changed Formula??

Problem 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 G14, 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 J12. Problem 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 G14, 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 J12