AND Function

Today I will discuss about a logical function ‘AND’ which is widely used in Microsoft Excel with other Logical functions like ‘IF’ as well as other functions.

We had already discussed about this function while discussing IF function, i.e., nested IF with AND function but we will discuss it here in detail.

Sometimes you may face situations where you should take decision based on the output of two or more conditions return TRUE otherwise the decision will be another.

Let’s take an example of an Examination in three subjects, if any student gets the pass marks (50) in all (three) subject in a test then only he will be declared as ‘PASSED’ else he would be declared as ‘FAILED’.

So normally we say that if Harry, a student, gets 50 marks in Subject 1 and 50 marks in Subject 2 and 50 marks in Subject 3 then he has ‘PASSED’ the test.

What we are doing here is we are testing each subject one after another whether the marks obtained is greater than 50 or not, if marks of any subject are less than 50 then the student will be called ‘FAILED’.

Here we can use AND function.

So, let’s discuss about AND function.

The Microsoft Excel AND function returns TRUE if all conditions are TRUE. It returns FALSE if any of the conditions are FALSE.

The AND function is a built-in function in Excel that is categorized as a Logical Function.

Syntax

The syntax for the AND function in Microsoft Excel is very simple

=AND(logical1, logical2, ... )

Parameters or Arguments

logical1

The first condition to test whether it is TRUE or FALSE.

logical2,

Returns

The AND function returns TRUE if all conditions are TRUE.

The AND function returns FALSE if any of the conditions are FALSE.

The below image will make it more clear.

How AND function Works

Example :

It is very easy to use AND function, type =AND( and then write the conditions separated by comma.

Suppose we have two numbers 101 & 111 in two cells C4 & D4, now if we write AND function the formula will be =AND(C4>100,C5>100) which will return TRUE because both the numbers are greater than 100.

If we write any number less than 100, the output will be FALSE.

This was simple,

now we will use this function with IF function, suppose we need to print “OK”, if both the values are greater than 100 and “Not OK” if any of the value is less than 100.

We will do it in simpler way, we will add IF function in the beginning of the above formula

=AND(C4>100,C5>100)

and the formula will be

=IF(AND(C4>100,C5>100),"OK","Not OK").

In same way, you can use AND function in other function (like SEARCH, FIND etc.) to make more complex formula as per requirement.

In the next article, we will discuss about OR function and there will make some more complex formula using AND & OR functions.

I hope you have enjoyed this article. Take care…

Thank you for reading….