In this article, we are going to learn about how and where we use AND function of Microsoft Excel.
Microsoft Excel AND function tests multiple conditions at the same time, up to 255 conditions and only if all conditions evaluate to TRUE, the function returns a TRUE response. If not, it returns FALSE as a result.
Let’s take examples and understand:-
We have a sample table of data, in which we have data in 2 columns and we want to match our conditions in both table.
Note:- As we have mentioned earlier, AND function can take up to 255 logical arguments and test them at the same time
Now let’s go to cell C9, and here we will test whether 5 is greater than 0 and B9 is less than A9 or not.
In this example, we will enter the arguments manually:-
Note:- As we have given the instructions to check whether all these logical tests are TRUE or NOT. If yes, then function will return TRUE else it would return FALSE.
In this example, we will learn another way to enter the argument:-
Now we’ll learn how AND function works for numbers only in the logical values:-
In this example, we’ll take 0 in the logical test, the function would return FALSE because “0” is always considered FALSE by OR
In these ways, we can use AND function in Microsoft Excel.
Watch the steps in this short video, and the written instructions are above the video
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.