Question: Enter the appropriate functions in cell L 5 to return the name of the greenhouse from the range P 5 :R 1 7 where the
Enter the appropriate functions in cell L to return the name of the greenhouse from the range P:R where the plant in A will be grown. The specific greenhouse where a plant is grown is based upon each plants days to harvest and hardiness. For example, since broccoli takes days to harvest and is a hardy plant, it should be planted in GHgreenhouse Use an IF function and an INDEX function to retrieve the greenhouse name for plants to be grown for the season. Plants that will not be planted should display a blank. Write the functions so that they can be filled down column L and return the name of the greenhouse for each of the plants in column A
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
