What function would be used in Excel

In cell E8, add a function that returns the value "Gold" if the value in the Courses field is greater than 4 and the number of courses equals the number of Honors earned in all courses taken. Gold status should be returned if both conditions are met; otherwise, the cell will be left blank. Copy the formula to E8:E24. the only cell that meets BOTH requirement is E15, therefore it is the only cell that returned "Gold". All the other cells will be blank. 9. Hints and explanation: Keyword here is "and". Returns true if BOTH conditions are met. See pages 199 and 200 You'll need quotes around all the text, "Gold" in this case The test: if the value in the Courses field is greater than 4 AND Courses and Num Honors are equal, then return the value Gold, otherwise the cell is to be left blank