IF Function

Written by kazamraza no comments
Classified in : Excel Formulas, Logical Functions Tags : none

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.

So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.

Syntax


IF(logical_test, value_if_true, value_if_False)

The IF function has a limitation, that it can evaluate only one logic/condition at a time. If we have more than one condition to evaluate,then we use AND function along with IF function.

 


For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).

 

IF is a multipurpose function.

.