Use if formula for the second part of the question .

Excel Basics-Student The Accounting Club wants to have a party for its members. The cost of renting a space and the cost of refreshments per person are given in the table below. The rental company will provide discounts on the rental space and refreshments if they have a larger group attend. # of People Attend in 0- 100 people 101- 200 people 201-300 people Cost for Refreshments per Person $15 $14 $12 10 301+ # of People Attendin 0-300 people 301+ Total Rental Cost $1,500 1,250 Other Data #Of Members Party B 325 7500 Required The Accounting Club wants to determine the cost of the party if 80% of the members attend and if all members attend the party. Determine the Total Cost and the Average Cost for the two attendance levels below Average Cost er Person # of Members Attend in Total Cost e(80% of members e (all members 325 If all members attend, the Accounting Club wants to determine if they can afford to invite all of the members' spouses Using an IF statement, determine if the Accounting Club can invite the spouses and stay within their budget. $7,500 650 Party Budget # of People Attending Total Cost Who should be invited