Excel - IF Function || IF formula || English article and Hindi Video

Excel IF Function

 

Summary

The IF function can perform a logical test and return one value subject to TRUE and FALSE value placed by you.

IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and whatever you want. For example, to avail incentive, branch should do more than 5 crores sell in a month: 

=IF(B2>5,"Eligible","Not Eligible")

So, IF function provided two results. First for your TRUE comparison and Second for FALSE comparison as an example given above.

Open this video to understand IF function with different data:

Above Youtube video link: https://www.youtube.com/watch?v=CQzsydfB_EE 

Purpose

IF is a conditional function, who helps us to find out a result on the basis of conditions entered by you.

 

Translation

=IF(B2>5,"Eligibile","Not Eligible")

If in the above formula value in “B2” is greater than 5, the return value is Eligible. Otherwise, Not Eligible.

 

Above Illustration providing text results and now we are going to return a mathematical result as image caption below.

In this function, if a value in “C2” is equal to Eligible, the branch will get 10% incentive for the sale amount (B2*10%). Otherwise, zero. 

To make it easy, open excel file via CLICK HERE and download.

Function Return Value

The value entered by you for TRUE or FALSE.

 

Arguments

 logical_test – The value evaluated as TRUE or FALSE.

value_if_true - The return value, when logical_test evaluates to TRUE.

value_if_false - The return value, when logical_test evaluates to FALSE.

 

Functions Used

Evaluation Operator	Meaning
=	Equal To
>	Greater Than (Angel Bracket)
“	Double Quote

 

Common Difficulties:

ERROR	Meaning of Error
#NAME? in cell	This usually means that the formula is misspelled.

 

Note: If you are going to use text in any function/formula, always wrap the text in double quotes (e.g. “Eligible”, “Not Eligible” as used above or “Done” etc.).