OR function in Excel, how to use the OR function, and examples
The following article details the meaning and usage of the OR - Logic function in excel.
Description: The OR function is a function that returns the logical value in Excel.
Syntax : OR (logical 1, [logical 2], .) .
Inside:
- logical 1, logical 2 are logical values ( True or False ).
- The function contains up to 255 logical values.
- The function's return value: the function returns True if one of the arguments has a True value , the function returns False when all of the arguments have a False value .
Attention:
- The arguments must be a logical value or a reference to an array containing the logical value.
- If one of the function arguments has a text value or a blank cell, these values are ignored.
- Where the entire value of the argument is not a logical value, the function returns the #VALUE error value .
- The OR function can be used in an array formula by pressing CTRL + SHIFT + ENTER .
For example:
Calculate the OR function value for the following logical values:
- In the cell to calculate the value of the formula: = OR (C6, D6, E6) .
Press the Enter function results OR when all the arguments have value TRUE is:
- Make a copy of the formula for the remaining values -> results:
- Where one of the arguments contains a text or a blank cell -> the return value is still a logical value.
- Where all arguments are text or a blank cell returns the #VALUE error value .
The above is a detailed guide on usage and common cases of the OR function .
Good luck!
You should read it
- DCount function in Excel - How to use the DCount function and examples using the DCount function
- INDIRECT function in Excel - How to use INDIRECT function and examples using INDIRECT function
- VLOOKUP function to use and specific examples
- Offset function in Excel - Usage and examples
- IRR function in Excel - Usage and examples
- The MID function in Excel, how to use the MID function, and examples
- DSUM function in Excel, how to use DSUM function and examples
- Function Address - The function returns the address of a cell in Excel (usage, examples, examples)
- How to use the SUMIF function in Excel
- Excel date function - Usage and examples
- PMT function in Excel - Usage and examples
- LEFT function in Excel, how to use LEFT function and illustrative examples
May be interested
How to get the current date in Excel
Group in Word, group of image blocks in Word
BETADIST function - Cumulative distribution function Beta in Excel
TTEST - Returns the probability associated with a Student's t-Test in Excel
ZTEST function - Returns the probability value on one side of the z test in Excel
VAR function - The function of estimating variance based on a sample in Excel