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

#### CONTENTS

# EXCEL FUNCTIONS-OR

## INTRODUCTION

*OR function comes under the LOGICAL FUNCTIONS category in Excel.*

*OR function is very important and is going to be used a lot which makes it one of the very important functions in excel.*

*It simply behaves like the binary OR. *

*It checks if ANY OF THE CONDITIONS are TRUE OR NOT.*

*IT returns TRUE if ANY OF THE CONDITIONS ARE TRUE and false , if ALL of the conditions is FALSE.*

## PURPOSE OF OR IN EXCEL

**OR FUNCTION RETURNS TRUE IF ANY OF THE CONDITIONS ARE TRUE AND FALSE IF ALL OF THE GIVEN CONDITIONS ARE FALSE.**

## PREREQUISITES TO LEARN OR

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

- Some information about the BINARY MATHEMATICS is an advantage for the use of such formulas.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.

## SYNTAX: OR FUNCTION

**The Syntax for the function is**

**=OR**(**CONDITION 1, CONDITION 2, CONDITION 3, …… SO ON****)**

**CONDITION1 Any condition (e.g. if any cell>12)**

**CONDITION2 Any condition (if any cell <45)**

**Atleast TWO CONDITIONS are needed. At the most, any number of conditions can be used.**

## EXAMPLE:OR FUNCTION IN EXCEL

### DATA SAMPLE

### STEPS TO USE OR

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

We are checking if the age is fulfilling the requirement for the selection which is, the age needs to be less than 20 or greater than 50

The formula is used as

=OR(G4<20,G4>50)

for the PERSON 1 and goes like this. for person 8 it is

=OR(G11<20,G11>50)

The cell number is the cell which contains the age of a particular person.

## KNOWLEDGE BYTES

### BINARY OR