Skip to content
**Our thanks, your savings. Limited Time Period Offer (Up to 85% OFF)**
# EXCEL FUNCTION – AND, OR, NOT

# Excel Function AND, OR, NOT

Microsoft Excel “AND, OR, NOT Functions” are the logical functions and helps to validate the statement if said is “TRUE” or “FALSE”. “AND, OR, NOT” are the three unique logical function and each one of them has their own characteristics.

“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”

“AND, OR, NOT Functions” has only one argument i.e. (logical) and multiple logical conditions can be placed in one function. It is easy to apply for validation and output is also very to understand i.e. “TRUE” and “FALSE”. We can place multiple logical conditions in one logical statement.

### 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

## Similar Posts

### EXCEL FUNCTION – MAX

### Excel Function – WEEKNUM Function

### EXCEL FUNCTION – HOUR, MINUTE, SECOND

### EXCEL FUNCTION – SUBSTITUTE

### EXCEL FUNCTION – REPT

### EXCEL FUNCTION – IFS

– 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!

MAX function is used to get the largest number in range or list of values. MAX function has one required argument i.e. number1

https://youtu.be/HmJL_y93pAs WEEKNUM function helps to calculate the week number of the given date in a year. It considers 1st January as first week by default and through the output for the given input date. Syntax:…

Microsoft Excel “HOUR, MINUTE, SECOND Functions” are time related functions helps to extract the Hour, Minute or Second from a complete Time.

SUBSTITUTE function is used to substitute the existing old text to new text.

REPT function is used to repeat the text or cell reference to multiple times

What is COUNTIFS in Excel? The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria and adjacent or non-adjacent. As a Statistical function of Excel,…