Share in Facebook


23 August 2018

OR Function


Like ‘AND’ logical function ‘OR’ function is also widely used in Microsoft Excel with other Logical functions like ‘IF’, ‘COUNTIF’, ‘SUMIF’ ‘AND’ etc., as well as other functions.Today I will discuss about the logical OR function in this article.









To understand OR function in Microsoft Excel let suppose I give you a funnel with a filter in it which can filter the return type of any condition.

Now, you pour all the condition to be tested (like, 100<90, 100 is less than 90) in this funnel and if ANY CONDITION return ‘TRUE’ then ‘OR’ function will return TRUE.

Let have another example to understand this function, suppose we have following data to be checked whether the return type is TRUE or FALSE.


Ø 90 < 75            à FALSE Statement
Ø 120 < 100        à FALSE Statement
Ø 75 < 200          à TRUE Statement
Ø 55 < 24            à FALSE Statement
Ø 34 < 23            à FALSE Statement
Ø 27 > 72            à FALSE Statement

From the above 6 statements we can understand that only ONE condition is TRUE, rest conditions are FALSE.
Therefore, ‘OR’ function will return TRUE.

How to use OR Function
How OR Function Works


Now let us discuss OR function in details.

Description

The Microsoft Excel OR function returns TRUE if any of the conditions are TRUE. Otherwise, it returns FALSE.

Syntax

The syntax for the OR function in Microsoft Excel is











=OR(logical1, [logical2...])

Note : Here logical means Conditions to be checked.

Parameters or Arguments

logical1

A condition to test that can either be TRUE or FALSE.

Logical2...

Conditions to test that can either be TRUE or FALSE. There can be up to 30 conditions.

Returns

The OR function returns TRUE if any of the conditions are TRUE.
The OR function returns FALSE if all conditions are FALSE.

Difference Between logical AND function & OR function

The syntax of both the function is almost same,

=OR(logical1, [logical2...])

=AND(logical1, [logical2...])

AND function returns TRUE when ALL the conditions are TRUE

on the contrary 

OR function returns TRUE when ANY ONE of the conditions is TRUE

I hope you have enjoyed this article. Take care…
Thank you for reading….

1 comment:

Prwatech said...

Very excellent post!!! Thank you so much for your great content. Keep posting.....

Apache Spark Online Course
Best Apache Spark Online Course