In cell B$8,$ determine if the guest's event is eligible for a discount.

To determine if a guest will receive a discount, the total cost of the event must be greater than or equal to $$20,000.$ If the event cost is greater than or equal to $$20,000,$ then the cost of the event should be multiplied by the discount calculated in cell B$7.$ If the event cost is not greater than or equal to $$20,000$ then the result will be a $0($zero$)$ discount.