Skip to content
# EXCEL FUNCTION – AND, OR, NOT

# Excel Function AND, OR, NOT

“AND, OR, NOT Functions” provide result in “TRUE” or “FALSE”. If the logical condition is correct and matching the parameters provided, then result would be “TRUE” or if logical condition is not correct and not matching the parameters provided then result would be “FALSE”

### Excel Function AND:

Output result of “AND” function will be “TRUE” if ALL the logical conditions of a logical statement are correct or matching as per parameters otherwise output result will be “FALSE”.

### Excel Function OR:

Output result of “OR” function will be “TRUE” if ANY of the logical condition from a complete logical statement is correct or matching as per parameters otherwise output result will be “FALSE”.

### “NOT” FUNCTION:

Output result of “NOT” function will be “TRUE” if NO logical conditions from a logical statement is correct or matching as per parameters otherwise output result will be “FALSE”.

### Advantage of “AND, OR, NOT Functions”

“AND, OR, NOT Functions” can be used in various databases whether it is Numeric/Alpha (Strings) etc. which makes the function useful and advantageous. Applying the logical function manually (one by one) to validate if logical condition is “TRUE or FALSE” is very difficult and “AND, OR, NOT Functions” helps to apply the function in large database at once and makes the work easy, saves time and increases efficiency.

### Where “AND, OR, NOT Functions” can be used:

## Recommended Articles

### Secrets of Excel Data Visualization: Beginners to Advanced Course

### Excel VBA Course : Beginners to Advanced

### Use Automated Excel Utility Tools to increase productivity

Hope you are enjoying learning Excel with us, if you want any support related to this article, please do comment else you can ask questions in Excel Community

## Similar Posts

### EXCEL TEXT FUNCTION

### EXCEL FUNCTION – WEEKDAY

### EXCEL FUNCTION – SUMIFS

### EXCEL FUNCTION – IF

### VBA Code to Remove Duplicate Rows

### EXCEL FUNCTION – SMALL

– Preparing Marks summary and providing Grades as per the marks obtained

– Selection of choices from the available multiple options

– Or any other database where there is requirement placing logical conditions then “AND, OR, NOT Functions” can be used

**Things to Remember:**

“NOT” function can have only one logical condition, whereas “AND, OR” may have multiple logical conditions in one logical statement.

Also, we need to understand the function output. i.e. “TRUE” means logical statement is matching however “FALSE” means logical conditions are not matching. Also ensure that correct cell reference is given otherwise function output and decisions may go wrong.

**“AND” Syntax:**

=AND(logical1, [logical2], …)

**Syntax Description:**

**logical,** argument is used to give the logical condition. We can place multiple logical conditions to check if conditions are TRUE or FALSE.

**Example 1: Explore “AND” Function**

“AND” function’s output will be “TRUE” only incase ALL the conditions are met. As per below example, logical statement is checking for rows# which is greater than 5 and greater than 50. Row#2 meets complete criteria that is why result is “TRUE” whereas Row#3 did not meet the second criteria (i.e. 40 is not greater than 50) that is why output result is “FALSE”

**“OR” Syntax:**

=OR(logical1, [logical2], ...)

**Example 2: Explore “OR” Function**

“OR” function’s output will be “TRUE” in case ANY of the following condition is met. As per below example, logical statement is checking for rows# which has either CAR or BUS. Row#2 meets the one criterion out of two that is why result is “TRUE” whereas Row#3 did not meet any of the criteria (i.e. value did not have either CAR or BUS) that is why output result is “FALSE”

**“NOT” Syntax:**

=NOT(logical1)

**Example 3: Explore “NOT” Function**

“NOT” function’s output will be “TRUE” in case NO logical conditions in a logical statement is met. As per below example, logical statement is checking for cells# which does not have “MARS”. Cell “A2” meets the criteria (i.e. Cell “A2” is SUN and not MARS”) that is why result is “TRUE” whereas output result of “A3” is “FALSE” (i.e. cell “A3” has “MARS”)

Hope you liked. Happy Learning.

Don’t forget to leave your valuable comments!

Here is another best rated Excel Charts and Graph Course from ExcelSirJi. This courses also includes On Demand Videos, Practice Assignments, Q&A Support from our Experts.

This Course will enable you to become Excel Data Visualization Expert as it consists many charts preparation method which you will not find over the internet.

So Enroll now to become expert in Excel Data Visualization. Click here to Enroll.

We are offering Excel VBA Course for Beginners to Experts at discounted prices. The courses includes On Demand Videos, Practice Assignments, Q&A Support from our Experts. Also after successfully completion of the certification, will share the success with Certificate of Completion

This course is going to help you to excel your skills in Excel VBA with our real time case studies.

Lets get connected and start learning now. Click here to Enroll.

- Quickly Move or Delete Files or Folder >> Click here
- Handle Duplicate Files with Automated Utlity >> Click here
- Generate Dummy Data For Testing >> Click here
- Excel Files and Sheets Consolidator >> Click here
- Manage Outlook Emails efficiently >> CLick here
- Send Bulk Emails wiht our Excel Automation >> Click here

TEXT function is used to change the formatting or appearances of the text. There are various types of formatting available.

WEEKDAY function applies to a Date and returns the output for Day of the week. The output of the function varies from 0 to 7

SUMIFS function is used to get the “total sum” of values for matching criteria across range. SUMIFS Function has required and optional arguments

In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE

Working with huge data is always exciting and challenging. From 2007 version onward, Excel is supporting more than a million rows in each worksheet. One of the common problems with huge data is “Duplicates” and the bigger problem is to identify and remove these duplicates. In this article, we will be sharing 4 ways to delete duplicate records from your data.

SMALL function is used to get the Smallest k-th value from the range.

SMALL Function has two required arguments i.e. array, and k