OR function in Excel – How to use, illustrative examples

To better understand the syntax as well as how to use the OR function in Excel spreadsheets, please follow the article below.

Instructions on how to use the OR function in Excel – Illustrative example

Syntax: OR (logical 1, [logical 2]…)

In there:

– Logical 1: Obligatory. Is a logical value.
– Logical 2: option. Is a logical value. Up to 255 different conditions are possible.

Function: Returns TRUE if any argument is TRUE, returns FALSE if all arguments are FALSE.

Consider for example: We have the following data table:

Request to find TRUE or FALSE of the given logical values ​​using the OR function. Apply the OR function. We have a formula for the value cell E5 to be: =OR(B5,C5,D5). Results:

Copy the formula for the remaining cells. Results:

Alternatively, you can enter the formula directly OR(1+1=3,2+4=6)

https://thuthuat.taimienphi.vn/ham-or-trong-excel-2329n.aspx
Above, we have introduced to you the OR function in Excel, the function returns TRUE if any argument is TRUE, is FALSE if all arguments are FALSE.