How would I write a formula for this in Microsoft Excel

B E F G H H K L M N 13 A Score 44 14 15 If Score is Greater than 89 From 80 to 89 From 70 to 79 From 60 to 69 Less than 60 Then Return A B a. Calculate the average of three scores shown in A14 to A16 = b. Write an IF statement to assign a letter grade to the average score = 70.67 90 16 78 Only use IF statements. Do NOT use VLOOKUP! 17 18 19 20 21 22 23 #3 24 Cost 1 25 26 $23 $20 $15 27 2 28 3 Gallon Cost/gallon if =500 and = 1000 gallons Number of gallons: 10 483 555 1000 2001 29 4 30 5 a. Write a formula to find the cost of 10, 483, 555, 1000 and 2001 gallons. (The formula should be able to 'copy' down from cell D29 to D33.) (Hint: Combine 'absolute' and 'relative' cell locations in your formula.) e.g. for 1000 gallons, it is 1000x$15 = $15,000 Be smart in your purchase 483 vs 555 gallons ! 31 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 6 32 7 33 8 34 35 36 37 38