In this formula, the following arguments are used:
if-expression: D2≥60, which checks to see if the student’s score is greater than or equal to 60.
if-true: "Pass", the value to return if the string in cell D2 is greater than or equal to 60.
if-false: "Fail", the value to return if the string in cell D2 is less than 60.
This formula assigns a "Pass" result if Student 1’s test score is 60 or higher; otherwise, "Fail" is returned.
Return a numerical value based on criteria: