Question: Using the Excel screen shot below, answer the following question: You want to return the Position name for all the people who have satisfaction scores

 Using the Excel screen shot below, answer the following question: You

Using the Excel screen shot below, answer the following question: You want to return the Position name for all the people who have satisfaction scores of 4 or higher. If they have a satisfaction score of 3 or less, you don't want to return anything; you want to leave it blank. What would your initial equation be in G2 knowing you were pulling it down to populate through G6? =IF(F2>=4,D2,0)=IF(F2>=4,D2,)=IF(F2>4,D2,)=IF(F2>4,D2,0)

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!