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:

 =IF(B3>15,"Bonus","No") 

Nested Usage Demonstration:

 =IF(H3<15,"0",IF(H3<25,"5",IF(H3<35,"7",IF(H3<50,"9","Nothing")))) 

Leave a Reply

YEAR Function

The YEAR function in Excel returns a 4-digit number representing the year component of date. This function allows you to

Read More »

What is Tableau?

Learning Tableau for Data Visualization Tableau is a data visualization tool used in business and academics. This software allows you

Read More »
Scroll to Top