Question: Insert an IF function in cell AC 1 4 to return the text High if the average purchase amount for Spring ( AA 1 4
Insert an IF function in cell AC to return the text "High" if the average purchase amount for Spring AA was greater than or equal to $ and "Low" if it was less than $ Repeat the steps for the remaining seasons. Hint: If you've sorted the data as described above you should be able to set your function to cover a specific group of rows based on which ones contain data for each season.
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
