#227-How to use OR Function in Excel

How to use the OR Function in Excel

Description

The OR Function is categorized as Logical Function in Excel. This function returns TRUE if any of the arguments of the OR function TRUE and returns FALSE if all the arguments are FALSE.

The OR function can takes up to 254 arguments.  It can also be used as a part of a formula.

Syntax

The syntax of OR function is =OR(logical1,[logical2] ...)

Argument or Parameter

Logical1 (Required)- A condition, value or reference that evaluates TRUE or FALSE. 

Logical1 (Optional) - A condition, value or reference that evaluates TRUE or FALSE. 

• If you use 0 then it evaluates as FALSE
• If any number other than 0 then it evaluates as TRUE

Returns

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

Example

Example-1

Example-2

Example-3

Example-4

Example-5

Example-6

********************************* ~:Support Our Work Financially:~ *********************************

Project File Type: Free

If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..

************************************************************************************************

LOGICAL FUNCTIONS
AND	FALSE	IF	IFERROR	IFNA
NOT	OR	TRUE	XOR