1.Richard asks you to calculate the membership prices for the first quarter memberships sold in the gallery ticket office. The individual membership price is $50. Students pay a discounted price of $25.

In cell F5, create formula using the IF function to determine the membership price based on the following criteria:

a.If cell D5 (the Category) is Student the price is 25. (Hint: Student must appear in quotes. Do not enter $ for the price.)

b.All other individual members must pay 50.