What is IF Function in MS Excel?

This is a very popular and easy-to-use function in MS Excel. This function is a logical function that is used to make a logical comparison between two values.

Purpose of IF Function in Excel

This function in Excel is used to make comparisons. The results are based on two conditions that are either ‘TRUE’ or ’FALSE’. It returns one value for the TRUE condition and a different value for the FALSE condition. The result of the IF function can be a cell reference, any value, or a formula as well.  

It can also be used in combination with other functions or formulas for example, AND, OR, etc.

Syntax of IF Function

The syntax of the IF function is written below.

=IF (logical_test, [value_if_true], [value_if_false])

Arguments

The arguments in the IF function in Excel are described below.

Logical_test: this is the argument that will return either the value TRUE or FALSE.

Value_if_true: this argument returns a TRUE value if the value given in logical_test is TRUE.

Value_if_false: this argument returns a FALSE value if the value given in logical_test is FALSE.

Examples

=IF (A1>75, TRUE)

The above example will return the value TRUE in case the value in cell A1 is greater than 75.