On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Monday, October 24, 2016

IF function in Microsoft Excel

IF Function uses, when we want output on the basis of a condition. IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. The IF function is a built-in function in Excel that is categorized as a Logical Function.

To make it more clear understanding for you,  This function tests a condition. If the condition is met it is considered to be TRUE. If the condition is not met it is considered as FALSE. Depending upon the result, one of two actions will be carried out.

Syntex:
 =IF(logical_test, [value_if_true], [value_if_false])  
 OR  
 =IF(Condition,ActionIfTrue,ActionIfFalse)  


Example:
The following table shows the Sales figures and Targets for sales reps.
Each has their own target which they must reach.
The =IF() function is used to compare the Sales with the Target.
If the Sales are greater than or equal to the Target the result of Achieved is shown.
If the Sales do not reach the target the result of Not Achieved is shown.
Note that the text used in the =IF() function needs to be placed in double quotes "Achieved".