Operation with condition according to the average


Firstly, you get the average score of three scores of one person by using AVERAGE() formula.

According to the gained average score, you can categorize the level of scores by using IF() formula.

Here, people whose average score are bigger than 300 are named as "satisfactory" whereas people whose average score are bigger than 400 are named as "good".