The IF function in Excel checks for a true or false condition. If the condition is true, the function returns a value, if the condition is false, the function returns another value

The function usually has 3 arguments: the condition you want to test, the return value if the condition is true, and the return value if the condition is false.

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

As you see, the IF function has 3 arguments, but only the first one is obligatory, the other two are optional.

**logical_test**– A value or logical expression that can be evaluated as TRUE or FALSE.**value_if_true**– [optional] The value to return when logical_test evaluates to TRUE.**value_if_false**– [optional] The value to return when logical_test evaluates to FALSE.

**Example**: For example, take a look at the IF function in cell B2 below.

**Syntax**: =IF(B2>80, “Good”,”Bad”)

**Result**:

**Same**: