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 AC14 to return the text "High" if the average purchase amount for Spring (AA14) was greater than or equal to $60, and "Low" if it was less than $60. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!