solve it by using Excel

Solve the following problem. Use IF function and use only the functions covered in the classroom. There are four tests in the table and each test has been repeated 3 times. There will be four averages total. (Use average function to find the average of the tests) You need to calculate the results per the equation given below. Test 3 Result 25 Trail 1 Trail 2 Trail 3 Average Test 1 87 86 89 Test 2 52 50 54 Test 4 54 32 76 20 21 * Result = Maximum Average of the four tests * 0.5 + Minimum Average of the four tests * 0.2 + The average of the two remaining averages * 0.3 Out of four averages one in maximum, one is minimum the other two are considered as two remaining averages