Excel IF() Function
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
if(Logical_Test, [value_if_true], [value_if_false])
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") |