How to use Excel AND Function (as Worksheet Function)

Excel Version in which AND function can work:

AND function will work in Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel Starter Excel Mobile Excel for Android phones.

About AND function:

AND function is a logical function which will test the multiple conditions.
This function will check for multiple conditions and returns TRUE if all conditions are true. Up to 255 conditions can be checked in one AND formula.
It can be used as a worksheet function and VBA function in macro code that is entered through the Microsoft Visual Basic Editor.
In this post we discuss about worksheet function. We will post about VBA function soon.

In most cases AND and IF function are used effectively to avoid nested IF function.

Syntax for AND:

=AND (logical1, [logical2], …)

logical1: The first condition to check whether TRUE or FASLE
logical2: another condition to check whether TRUE or FASLE. (Optional)

Using AND function:

We can see how to use AND with some examples.

and function

In case, If we want to check one or more conditions and get the result TRUE if all conditions are satisfied, if any of the conditions are not satisfied it will give the result FALSE.

Finally, below are few examples about using this function.

Condition 1Condition 2FormulaResult
100200 =AND(B3>10,C3<1000)TRUE
5200 =AND(B4>10,C4<1000)FALSE
1001200 =AND(B5>10,C5<1000)FALSE


Add a Comment

Your email address will not be published. Required fields are marked *