Excel tutorials

In Excel we can assign a pass or fail grade to students based on score for an exam.

Enter some student names and grades in Excel like below:

Now for the grades in column C – we are going to make use of the =IFS() function

This function checks multiple conditions and returns the corresponding value to the first true condition.

Lets say that grades over 80 is an A, over 49 it is B, and below 50 it is C.

Enter the following formula in C2:

=IFS(B2>80;”A”;B2>49;”B”;B2<50;”C”)

Drag the formula down to fill all the cells: