Pass or fail formula in excel | how to use if function in excel

IF

Use of IF Function in Excel

This is a logical function in Microsoft Excel.
This function in Microsoft Excel checks whether a condition is met and give one value for TRUE result and another value if FALSE result

Syntax / Formula of IF function

The syntax of IF function in Microsoft Excel is below

=IF(logical_test, [value_if_true], [value_if_false])

Logical Operators

We can use any of the following Logical Operators:

Symbol of Operators	Meaning
=	Equal to
>	Greater Than
>=	Greater Than or Equal to
<	Less Than
<=	Less Than or Equal to
<>	Not Equal to

Example of IF Function in Excel.

In this example Student result is based on below criteria.

If any student get total marks more than or Equal to 140 then result is "Pass"

If any student get total marks Less than 140 then result is "Fail"

Step 1: First create below table in your excel starting from cell range A1:D11

Step 2: Type formula =IF(C2>=140,"Pass","Fail") in cell D2 and press enter.
In this formula C2>=140 is our logical_test

[value_if_true] is "Pass"

[value_if_false] is "Fail"

IF FUNCTION