In cell F2, enter an IF function with a nested AND function to test for Afternoon profits (in cell

B2) greater than or equal to $100 (cell E2), and that returns the word BEST when both

conditions are met, and that leaves the cell blank if conditions are not met.

Begin the formula =IF(AND(b2-"Afteroon"

, and then complete the formula. You will not see

a result in cell F2 because if does not meet the conditions. Copy the formula down through cell

F15- only two cells will meet the conditions. Use the conditional formatting rule Text that

Contains to format the cells with a red border for those days that meet both conditions.

Shift Cups sold (12 oz) Profit Sales over Shift Kids Size Sold Cups Sold $100 Sold (602) 24 11 54 52 14 28 Morning Afternoon Evening 52 110 64 124 248 161 Day 1 2 Sun 3 Sun 4 Mon 5 Mon 6 Tue 7 Tue 8 Wed 9 Wed 10 Thu THU 12 Fri 13 Fri 14 Sat Morning Afternoon Afternoon Evening Afternoon Evening Afternoon Evening Afternoon Evening Afternoon Evening Morning Afternoon GES 22 23 26 9 8 128.59 110.17 35.34 61.66 37.22 47.00 54.52 63.54 75.20 77.46 89.11 125.21 163.18 188.75 13 15 17 19 36 54 70 74 28 44 1 18 Scenario Sunrimary Smoothie Costs Weekly Sales Supervisor Awards