Question

In an excel sheet containing 10 students with their scores in four subjects,if the minimum pass mark is an average score of 60,write a formula to determine if a student passed or failed.

Answer 1

Answer:

I have this year result of students so I need to calculate if a person is pass or fail the pass mark is 38 but also a need to format the pass and fail next the result to appear in colour example pass appear in green colour the format of the colour that I need to appear when the fail and pass it might occur we see how q&a this section is not written yet want to join in click added to write this answer