Problem 1 Part II: Jamie and Emily want you to recalculate the amount charged from each \ attendee based on the fact that new members must pay a joining fee of $50. \ That is, a new member (Y) pays $50 plus the class cost based on their type (Regular, Student, \ or Youth). A returning member (N) pays the class cost only, as shown below. Use Nested IF \ Statements.\ You should enter a formula in F13, and then auto-fill the rest of the column.\ Make sure to use cell references, and not enter specific number in your formula