Hi there, I have a question with my Excel class. The problem is about IF and IND

Question

Hi there,

I have a question with my Excel class. The problem is about IF and INDEX function. Here is the question.

Enter the appropriate functions in cell L5 to return the name of the greenhouse from the range P5:R17 where the plant in A5 will be grown. The specific greenhouse where a plant is grown is based upon each plant’s days to harvest and hardiness. For example, since broccoli takes 49 days to harvest and is a hardy plant, it should be planted in GH1 (greenhouse 1). Use an IF function and an INDEX function to retrieve the greenhouse name for plants to be grown for the 2018 season. Plants that will not be planted should display a blank. Write the function(s) so that they can be filled down column L and return the name of the greenhouse for each of the plants in column A.

Here is the Link to the excel sheet (it is an exe file which contains the excel file and the instruction document.)

https://drive.google.com/open?id=1uUIsH14uOI-rzinlJlpMXXq0KmAdUqjd

PLANT DATA FOR 2018 PLANNING 2017 flats Hardincss Greenhouses fon Days to Germination holesalearly bird l)ay% to harvest Hardiness failurc tcost per flat scason Prescasonscasonchange 2018 ation reenhouse Plant hardy tender Chinese cabbage Mustard greens Sweet potato Documentation Plant Data Revenue_Projections Markup_List Scheduling + 52

Explanation / Answer

Syntax of the INDEX function that we use in this question"

INDEX(table, row_number,column_number)

table

A range of cells that contains the table of data.

this is apply to the given question such

ig all entries make done according in MS-Excel that it is K th location according to the question so we assume that is Table can be drawn so WRITE formulae in above excel sheet

fx=INDEX(A3:K3,3,3)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.