## IF Function

Written by kazamraza
no comments

Classified in : Excel Formulas, Logical Functions

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.