The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value for “True” and another for “False”. What is unique about the IF function is that you can utilize multiple conditions. You can also use the IF Function in combination with other functions. Using multiple IF Functions in the same formula is also an option. This practice is known as nesting and is outlined below.
=IF (logical_test, [value_if_true], [value_if_false])
Syntax Explanation:
- logical_test – A value or logical expression that can be evaluated as TRUE or FALSE.
- value_if_true – Result when logical_test is TRUE. (Optional Field)
- value_if_false – Result when logical_test is FALSE. (Optional Field)
Comparison Symbols | Meaning |
= | equal to |
> | greater than |
>= | greater than or equal to |
< | less than |
<= | less than or equal to |
<> | not equal to |
Normal Usage Demonstration:
=IF(B3>15,"Bonus","No")
Nested Usage Demonstration:
=IF(H3<15,"0",IF(H3<25,"5",IF(H3<35,"7",IF(H3<50,"9","Nothing"))))