O=1. First Resource is offering a 5% discount off registration fees for all 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.

2. First Resource also offers a 3% discount off registration fees if the 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.