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.
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.