First Resource is offering a 5% discount off registration fees for all 12 EventTypes except for Survey/Study. In cell K11 enter a formula that will return 0.05 if the event is NOT a Survey/Study, otherwise return a blank value (""). Use a VLOOKUP function to return the EventType from the EventDetails named range. Use a NOT function so that any event type other than Survey/Study will return TRUE. Use an IF function to return 0.05 for the value_if_true and ""for the value_if_false Incorporate an IFERROR function to return a blank value if the VLOOKUP function returns an error. Format the result as Percentage with 0 decimal places and copy the formula down through K34. 6 First Resource also offers a 3% discount off registration fees if the 10 registrant meets certain criteria. In cell L11, enter an IF function that will return 0.03 if the following criteria are met, otherwise return a blank value (""). If the registrant is a board member and had 3 or more people in the party OR the registrant has a total of 5 or more in their party. Format the result as Percentage with 0 decimal places and copy the formula down through L34. In cell M11, enter a formula that will calculate the total amount due 10 after discounts have been applied. Incorporate an IFERROR function to return a blank value ("") if formula returns an error. Format the result as Accounting and copy the formula down through M34