Excel IF() Function: The IF() function in excel checks whether a condition is true or not and returns one value if the condition is TRUE and another value if it’s FALSE.

Syntax

Parameter

Logical_Test (required)- This parameter represents the condition which you want to check (greater than, less than or equal to signs can be used for numbers). When you want to evaluate a condition based on text value, then use double quotes (”) with equal to signs.

value_if_true (optional)- This parameter represents the logical test value, and if it holds the value, then excel will return this value.

value_if_false (optional)- If the logical test does not hold, then excel will return this value.

Category

Logical

Return

The function returns one value if the condition is TRUE and another value if it’s FALSE.

Example 1

Objective: Using IF formula to identify if a student has passed an exam or not

Student Name Marks Pass or Fail Formula
Mukta 80 Pass  =IF(B2>=30,”Pass”,”Fail”)
Arvind 60 Pass  =IF(B3>=30,”Pass”,”Fail”)
Jyotsna 29 Fail  =IF(B4>=30,”Pass”,”Fail”)
Amar 11 Fail  =IF(B5>=30,”Pass”,”Fail”)

Example 2

Objective: Using the IF Function, check whether the student has passed or not. If the student has failed in 1 of the 2 subjects, then the student will be considered as Failed.

Student Name Subject 1 Subject 2 Overall Result Formula
Reeta PASS PASS PASS  =IF(AND(B26=”PASS”,C26=”PASS”),”PASS”,”FAIL”)
Sweta PASS FAIL FAIL  =IF(AND(B27=”PASS”,C27=”PASS”),”PASS”,”FAIL”)
Baani FAIL PASS FAIL  =IF(AND(B28=”PASS”,C28=”PASS”),”PASS”,”FAIL”)
Aditya PASS PASS PASS  =IF(AND(B29=”PASS”,C29=”PASS”),”PASS”,”FAIL”)

Pin It on Pinterest

Share This