how do i write the formula for e4

Event Analysis 9 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 15 argument to retrieve the bonus amount the event coordinator will receive. Format the result as Accounting and copy the formula down through E9