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
- PMT function in Excel - Usage and examplesthe pmt function is one of the built-in financial functions of the excel software used to calculate the payment for a loan based on regular payments and a constant interest rate. the pmt function is not only useful for businesses, but also very practical for users if you want to calculate a loan.
- GAMMAINV function in Excel, how to use and examplesthe gammainv function in excel helps calculate the inverse value of the cumulative gamma distribution, which is used in statistics and data analysis. this article will guide you on how to use the gammainv function with specific illustrative examples.
- How to use the MAXA function in Excel, detailed examplesthe maxa function in excel helps find the largest value in a data set, including numbers, logical values, and text containing numbers. this is different from the max function, which only counts numbers. let's learn the syntax and usage of the maxa function with practical examples.
- LEFT function in Excel, how to use LEFT function and illustrative examplesleft function in excel, how to use left function and illustrative examples. left function in excel is a function of string processing function, you use left function when you need to cut the character string to the left of the text string. if you need to learn more about mid functions, be patient
- How to use the SUMIF function in Excelthe sumif function in excel is a function used to compute values in a specified range. the sumif function can be used for summing cells based on the date, data and text that are connected to the specified area.
- Choose function in Excel, how to use the Choose function and illustrative exampleschoose function in excel, how to use the choose function and illustrative examples. you are looking for ways to use the choose function in excel so you can use the choose function quickly. so, please refer to the following article to know the choose function syntax, for example how
- DCOUNT function in Excel - Usage and practical examplesthe dcounta function is one of many frequently used math functions in excel. the dcount function helps you count non-blank data cells in list columns or data arrays with defined conditions.
- The function takes whole parts in Excel - Specific examplesthe function takes whole parts in excel - specific examples. excel has 2 functions that involve taking integer parts: quotient, int. there are many people who have a confusion between these two functions, only when you understand the nature of each one can you use them most accurately.
- Random function in Excel (RAND function), how to use the Random function and examplesrandom function in excel (rand function), how to use the random function and examples. you need to get a random value in a range of values. to avoid duplicate values and objectivity, you should use the rand () function. the article below gi
- FIND function in Excel - Usage and examplesfind function in excel - usage and examples. the find function in excel is a function of the text function group, you can use the find function to find the position of a substring of text in another text. to understand more about the find function, how to use it and the examples used in the find function