*PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES*

#### CONTENTS

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

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

### STEPS TO USE IF

The example has 8 persons with ages given in the next column.

## KNOWLEDGE BYTES

### NESTED IF