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 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
Get step-by-step solutions from verified subject matter experts
