When you have provided the correct formula, you should see the following result: A 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 956 8 82 20 No 2 18 Special Order 1 2 7 No 10 9 5 2 6 3 11 No 7 6 6 8 7 12 9 10 9 11 868 3 232 6 14 No 1 16 Special Order 9 3 10 9 12 11 88 8 620 20 4567 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". 17 Otherwise, mark it with "No". Special Orderi Enter the correct formula for F2. Use only relative addressing for the cell so that it can be easily filled down the column