Specifies a logical test to perform
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.
Expanding on the basic example above:
The arguments for the IF function are:
||Any value or expression that can be evaluated to TRUE or FALSE.
||The value that you want to be returned if the logical_test argument evaluates to TRUE.
||The value that you want to be returned if the logical_test argument evaluates to FALSE.
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.