The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value for “True” and another for “False”. What is unique about the IF function is that you can utilize multiple conditions. You can also use the IF Function in combination with other functions. Using multiple IF Functions in the same formula is also an option. This practice is known as nesting and is outlined below.

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

Syntax Explanation:

  • logical_test – A value or logical expression that can be evaluated as TRUE or FALSE.
  • value_if_true – Result when logical_test is TRUE. (Optional Field)
  • value_if_false – Result when logical_test is FALSE. (Optional Field)
Comparison SymbolsMeaning
=equal to
>greater than
>=greater than or equal to
<less than
<=less than or equal to
<>not equal to

Normal Usage Demonstration:


Nested Usage Demonstration:


Leave a Reply

CONCAT Function

The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016

Read More »

PMT Function

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate.

Read More »
Scroll to Top