Answer:
The IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result.
For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail"). More than one condition can be tested by nesting IF functions.
Comparison operator:
Meaning