B D 1ja Calculate the total cost of each order using "IF" function. Cost/gallon for the first 500 gallons Cost/gallon for gallons above 500 gallons $24 $20 Total Cost a. 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 b 18 19 20 21 b. c. d. 10 483 511 1500 Gallons gallons gallons gallons Calculate the total cost of each order using "IF" function. Cost/gallon for the first 500 gallons Cost/gallon for the next 500 gallons Cost/gallon for gallons > 1000 gallons $24 $20 $15 22 Cost a. b. 1600 483 2001 Gallons gallons gallons C. 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Sheet1 Sheet2 Normal View Ready