The IF function is a "must know" function in Excel. It can be used in a very simple manner, but it can also be used to solve very complicated logical conditions. The basic use of the IF function would is to test a single condition and provides one result for true and another result for false. However, the results themselves can be another IF function or other functions - this is typically referred to as "nested IF statements". Becoming comfortable with the IF function and discovering what can be done with it are a very worthwhile investment of your time.

IF takes 1 required argument and 2 optional arguments:

Syntax: IF(logical_test, [value_if_true], [value_if_false])

#1)
A basic IF function:
#2)
Expanding on the basic example above:
#3)
Let's try nesting:
#4)
One more thing:
#5)
The arguments for the IF function are:
Argument Required? Description
logical_test Required Any value or expression that can be evaluated to TRUE or FALSE.
value_if_true Optional The value that you want to be returned if the logical_test argument evaluates to TRUE.
value_if_false Optional The value that you want to be returned if the logical_test argument evaluates to FALSE.

Summary

The IF function is a "must know" function in Excel that can be used in a either a very simple manner or in very complicated decision making logic.
comments powered by Disqus