How to Use IF Function in Excel

Summary

The IF Function is used to perform logical test and return the one value for TRUE result, and another for FALSE result. The IF functions can be use with functions like AND, OR etc.

Purpose

The the specific condition is TRUE or FALSE

Syntax

= IF ( logical_test, value_if_true, value_if_false )

Arguments

logical_test: The logical test for which to evaluate the result
value_if_true: This argument is optional. The value to return when logical_test is TRUE
value_if_false: This argument is optional. The value to return when logical_test is FALSE
if function in excel

Example Explanation

In the above mentioned example we have use the IF function to find out if student is Pass or Fail based on their passing score. Our passing score for this example is 70. Formula used in D6 is:

Logical Operators in IF Function

Comparison operatorMeaning
=Equal to
>Greater than
<Less Than
>=Greater than or equal to
<=Less than or equal to
<>Not equal to

scroll to top