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

Practice: Basic functions-IV

Practice: Basic functions-IV

Using basic functions with more practices.


Profitability of a Theater

Profitability of a Theater

Using four operations and statistical functions over a scenario which is related plays tickets status of a theater.


Richest Business People

Richest Business People

Look at the some of richest people in the world. A table of these people age, earnings, the company owned by those compa...