When you have provided the correct formula, you should see the following result: B C D E F 1 Order# Apples Oranges Pears All Fruit Special Order? 2 1. 5 3 1 9 No 3 23 2 3 3 11 4 5 4 4 9 5 2 7 6 6 8 7 12 6 10 11 868 3 156 623T 9 822 8 20 No 2 18 Special Order 2 7 No 6 3 11 No 6 14 No 3 1 16 Special Order 1 9 3 10 9 12 11 88 20 4567 620 4 8 No 5 17 No 6 21 Special Order 35 Special Order 13 14 If the maximum number of any one fruit exceeds 10 pieces in an order, or the total order exceeds 20 pieces (all fruit), 15 16 then mark it with "Special Order". 37 Otherwise, mark it with "No". Special Order Enter the correct formula for F2. Use only relative addressing for the cell so that it can be easily filled down the column