Explanation
Logical functions evaluate a condition and return a result based on whether the condition is TRUE or FALSE.
Important Logical Functions
|
Function |
Purpose |
|
IF |
Returns one result if TRUE and another if FALSE |
|
IFS |
Tests multiple conditions |
|
AND |
TRUE when all conditions are TRUE |
|
OR |
TRUE when at least one condition is TRUE |
|
NOT |
Reverses TRUE/FALSE |
|
IFERROR |
Replaces an error with a specified result |
|
IFNA |
Handles #N/A errors |
Example
|
Student |
Marks |
|
Amit |
75 |
|
Neha |
38 |
|
Rahul |
62 |
Formula:
=IF(B2>=40,”Pass”,”Fail”)
Result
|
Student |
Marks |
Result |
|
Amit |
75 |
Pass |
|
Neha |
38 |
Fail |
|
Rahul |
62 |
Pass |
Practice
Create a student result sheet and use IF to determine Pass/Fail.