Use of AND Function
The AND function is used to verify multiple logical conditions simultaneously, up to 255 conditions supplied as arguments. Each argument (logical1, logical2, etc.) must be a TRUE or FALSE-returning expression or a TRUE or FALSE-evaluable item. Constants, cell references, arrays, and logical expressions can be used to input the AND function.
Example-
If A1 cell contains 40.
=AND(A1>0,A1>8,A1<90) // returns TRUE
=AND(A1>0,A1>8,A1<20) // returns FALSE
Note-
-
The AND function is not case-sensitive.
- Wildcards are not supported by the AND function.
- Arguments of text values or empty cells are ignored.
- If no logical values are identified or created during evaluation, the AND function will return #VALUE.
We will see an example to understand AND function better-
Take the following data.
Enter the following formula in the B1 cell.
Now move the cursor on the vertex of the B1 cell and drag it to the B4 cell. The resulting output will be like this-
Excel OR Function
If any of the given conditions are true, the OR function in Excel returns TRUE; otherwise, it returns FALSE. Let us learn how to use the OR function in Excel by combining it with other functions.
Purpose : OR can be used to test multiple conditions.
Return value :If any of the arguments evaluate TRUE, TRUE; otherwise, FALSE.
Syntax : =OR (logical[1], [logical[2], ...)
Arguments
- logical1 - The first condition to assess is the logical value.
- logical2 - [optional] The second condition to evaluate is the logical value.
Use of OR Function
If any specified parameters are TRUE, the OR function returns TRUE and FALSE if all the supplied arguments are FALSE.
The OR function examines many logical conditions simultaneously, up to 255, which are supplied as arguments. Each argument (logical1, logical2, etc.) must be a TRUE or FALSE-returning expression or a TRUE or FALSE-evaluable item. Constants, cell references, arrays, and logical expressions can all be used to input the OR function.
If A1 cell contains 40 -
=OR(A1>5,A1>67,A1>90) // returns TRUE
=OR(A1<5,A1=30,A1>90) // returns FALSE
Note-
- Each logical condition must return TRUE or FALSE or be arrays or references with logical values.
- Arguments of text values or empty cells are ignored.
- If no logical values are discovered, the OR function will return #VALUE.
We will see an example to understand OR function better-
Take the following data.
Enter the following formula in the B1 cell.
Now move the cursor on the vertex of the B1 cell and drag it to the B4 cell. The resulting output will look like this-
FAQs
1. How can we use AND function with IF function?
The AND function can be used inside the IF function. You can supply AND as the logical test for the IF function. Now we will learn about through an example -
2. How can we use OR function with IF function?
OR is a function that can extend the functionality of other functions, such as the IF function. For an IF function, you can supply OR as the logical test. Now we will learn about it through an example -
3. What is the array form of the OR function?
Against a criterion, we can test all values in a range by using OR as an array formula. For example, if any cell in A1:A5 is larger than 15, this array formula will return TRUE:
4. What is a wildcard?
A wildcard character is a unique character that allows you to do "fuzzy" text matching in Excel calculations.
Example-
= COUNTIF(A1:A5,"*ninja")
5. How can we combine the OR function with the WEEKDAY ?
In Excel, the WEEKDAY function returns a number ranging from 1 (Sunday) to 7 (Saturday) that represents the date's weekday. As a result, if the date falls on a weekend, the OR function returns TRUE.
Key Takeaways
In this article we have extensively discussed the topic of AND and OR function. Furthermore, we learned how to manipulate data using AND and OR function.
We hope that this blog has helped you enhance your knowledge regarding encryption and if you would like to learn more, check out our articles on ABS Function and Pie chart.
Refer to our guided paths on Coding Ninjas Studio to learn more about DSA, Competitive Programming, JavaScript, System Design, etc. Enroll in our courses and refer to the mock test and problems available. Take a look at the interview experiences and interview bundle for placement preparations.
Do upvote our blog to help other ninjas grow.
Happy Learning!
85+ registered 