formula for d4 and or e4 please ive tried many formulas and all of them are inccorect

Event Analysis 8 On the EventAnalysis worksheet, in cell D4, enter a formula that will return Goal_Met if the number of registrants for the event meets or exceeds the goal for that event outlined in the cell range G4H9, othervise return Promote_Event. Copy the formula down through D9. First Resource offers a bonus to the coordinator for each event. The bonus amount is based on the event type and the number of registrants. In addition, there are different amounts awarded if the registration goal has been met or not. Create a Goal_Met named range for cells H14:L17 and a Promote_Event named range for cells H21:L24. 10 In cell E4 enter an INDEX function that incorporates the INDIRECT function for the array argument to retrieve the bonus amount the event coordinator will receive. Format the result as Accounting and copy the formula down through E9. Event Analysis