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".

Related Trainings

Highest Paid Celebrities

Highest Paid Celebrities

Look at the World's Highest-Paid Celebrities. Gain more insights using rankings, basic statististics and conditional sta...


iPhone vs Samsung

iPhone vs Samsung

Checking formulas results with Iphone-Samsung sales.


Most Popular Movies

Most Popular Movies

Getting produced year of popular films of the IMDB from unformatted title information with year. Also calculating votes ...