Question: I completed the first part which is below: First Resource offers a bonus to the coordinator for each event. The bonus amount is based on

I completed the first part which is below: First Resource offers

I completed the first part which is below:

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.

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.

I cannot figure out the index formula please help.

=IF(INDEX(INDIRECT("Goal_Met"),4,3, Goal_Met)) F H j K L M Registration Goal 20 70 C D E 3 TotalRegistrants Action Bonus 4 23 Goal_Met =IF(INDEX 5 66 Promote_Even 6 27 Goal_Met 7 38 Promote_Even 8 21 Goal_Met 9 24 Promote_Even 10 G EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 25 40 20 25 11 12 13 14 Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $160.00 $ 180.00 $ 200.00 $ 220.00 160.00 $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $160.00 $ 180.00 $ 200.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 15 16 17 18 19 20 21 Promote Event 20 25 30 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $ 90.00 $110.00 $ 130.00 $ 150.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 22 23 24 25 26 27 28 =IF(INDEX(INDIRECT("Goal_Met"),4,3, Goal_Met)) F H j K L M Registration Goal 20 70 C D E 3 TotalRegistrants Action Bonus 4 23 Goal_Met =IF(INDEX 5 66 Promote_Even 6 27 Goal_Met 7 38 Promote_Even 8 21 Goal_Met 9 24 Promote_Even 10 G EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 25 40 20 25 11 12 13 14 Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $160.00 $ 180.00 $ 200.00 $ 220.00 160.00 $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $160.00 $ 180.00 $ 200.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 15 16 17 18 19 20 21 Promote Event 20 25 30 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $ 90.00 $110.00 $ 130.00 $ 150.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 22 23 24 25 26 27 28

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Question 10 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...

I need some help with starting my Excel homework Start Excel. Download and open the file named Excel_Ch05_PS1_ResourceCenter.xlsx. Grader has automatically added your last name to the beginning of...

I need some help with my excel homework and it's a lot to take in Registration fees, located in the EventDetails table, are based on a particular Event's EventID. Registration fees must be paid for...

Please complete steps g and h. work is related to excel. Previous steps are listed if needed to understand g and h. A formula is needed for cell m11 on client registration worksheet and a formula for...

9 a 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...

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...

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...

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...

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...

Consider the following ERD for a Dental Clinic and solve the following questions. Dentist PK dentNum: char(5) grade: char(2) denName: vrachar(25) address: varchar(25) yearsOfService: char(2) Nurse PK...

Company A from Sections 4 and 5 decides during year 2 of its existence to repurchase some of the 10 million shares it issued A total of 1 million shares are repurchased at a cost of $ 20 per share...

all the following are considered to be changes in accounting policy except for 1 - The initial adoption of a new accounting standard 2 - A change in accounting for a defined benefit pension plan from...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

Identify examples of mind reading, and describe their impact on Marthas and Andys discussion.

Attend a meeting of a political or civic group that interests you. Take notes on climate-building communication. For instance, do people at the meeting express empathy, openness, spontaneity, and so...

To what extent do you think Andy and Martha feel listened to by the other?