# EXCEL FUNCTIONS-IF

## INTRODUCTION

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

### DATA SAMPLE

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.