Operation with nested IF()

Firstly, you decide about the condition of getting good, average and poor level.

Here, in IF() function,  if the average score of the student is higher than 70, the level will be "good".

If the average score of the student is higher than 20, the level will be "average"; if not, the level will be "poor".

Since there are three different conditions, there should be two IF() functions, namely nested IF() functions.

Related Trainings

 Building MAX + IF and MIN + IF with one condition - Example 2

 Building MAX + IF and MIN + IF with one condition - Example 2


Salesperson Ratings

Salesperson Ratings

Create a summary of salesperson sales stats with the help of range lookup.


Vacation Day Calculator

Vacation Day Calculator

Calculate vacation days based on years worked and other conditions