IF function comes under the LOGICAL FUNCTIONS category in Excel.
IF function is very important and is going to be used a lot which makes it one of the very important functions in excel.
Its the simplest function to insert any condition in excel.
IF checks if certain condition is true or not and places certain value if the condition is true and some other value if the condition is false.
PURPOSE OF IF IN EXCEL
IF FUNCTION CHECKS THE GIVEN CONDITION AND SETS THE VALUE AS PER THE OUTCOME OF CONDITION.(TRUE OR FALSE)
PREREQUISITES TO LEARN IF
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
Helpful links for the prerequisites mentioned aboveWhat Excel does? How to use formula in Excel?
SYNTAX: IF FUNCTION
The Syntax for the function is
=IF(CONDITION TEST, VALUE IF CONDITION IS TRUE, VALUE IF CONDITION IS FALSE)
EXAMPLE:IF FUNCTION IN EXCEL
Suppose we have to find if a person is KID or ADULT.
A person i s a kid if age<18 and adult if age>=18.
We’ll place it against the persons if he is kid or adult.
STEPS TO USE IF
The example has 8 persons with ages given in the next column.We are checking if a person is kid or adult.The formula used is=IF(F7<18,”KID”,”ADULT”)The output is shown in the picture. The first phrase is F7<18 checks if the value present in F7 is less than 18.If yes, KID will be put as the value, if not , ADULT.The output is shown.
In many situations we’ll find a case where we will be having more than one conditions.In that case , we can make use of NESTED IF .The notation goes like this. =IF(condition1, value1,(if(condition 2,value 2, value 3))if condition 1 is true, value 1 will go otherwise control will go to next condition,if condition 2 is true, value 2 will come else value 3.