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
- 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
May be interested
- How to get the current date in Excelthe following article summarizes the common ways to get the current date in excel fastest.
- Group in Word, group of image blocks in Wordto facilitate the movement and positioning of images in large image blocks, you should use the group feature. the following article shows in detail how to group in words and image blocks in word 2007 2010 2013 2016.
- BETADIST function - Cumulative distribution function Beta in Excelthe betadist function is used to calculate the probability distribution according to the beta distribution, in which the beta distribution is used to study the variation of samples as a percentage.
- TTEST - Returns the probability associated with a Student's t-Test in Exceldescription: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- ZTEST function - Returns the probability value on one side of the z test in Excelztest function: the function returns the one-sided probability value of the z test. for the hypothetical population mean, the function returns the probability that the sample mean will be greater than the sample mean observed in the data set or array.
- VAR function - The function of estimating variance based on a sample in Excelvar function: the function performs an estimate of the latter based on a sample from a given set. function arguments can be numbers, names or arrays, or references containing numbers.