Summary
The IF Function is used to perform logical test and return the one value for TRUE result, and another for FALSE result. The IF functions can be use with functions like AND, OR etc.
Purpose
The the specific condition is TRUE or FALSE
Syntax
= IF ( logical_test, value_if_true, value_if_false )
Arguments
logical_test: The logical test for which to evaluate the result
value_if_true: This argument is optional. The value to return when logical_test is TRUE
value_if_false: This argument is optional. The value to return when logical_test is FALSE
Example Explanation
In the above mentioned example we have use the IF function to find out if student is Pass or Fail based on their passing score. Our passing score for this example is 70. Formula used in D6 is:
Logical Operators in IF Function
| Comparison operator | Meaning |
| = | Equal to |
| > | Greater than |
| < | Less Than |
| >= | Greater than or equal to |
| <= | Less than or equal to |
| <> | Not equal to |
