Using multiple criteria with the “AND” functions

Sometimes you need to check more than one criteria with the If statement. You can Use "AND" functions for that.

For example:

Only if the student has grades greater than
80 in HINDI, greater than 80 in English and greater than 80 in ,MATH
only then write “good”, else write “Average”.


Name HINDI ENGLISH MATH REMARKS
A 81 81 81 GOOD
B 80 81 81 AVERAGE

The way to implement such a case is using the “AND” function which will
include all the multiple criteria inside of it.

You can read about more if functions and criteria from the bellow link
IF Statement
OR function with IF
IF function Examples