top of page
  • Writer's pictureDp

"AND" Function in Excel

Updated: May 2, 2019

This function tests two or more conditions to see if they are all true. It can be used to test that a series of numbers meet certain conditions. It can be used to test that a number or a date falls between an upper and lower limit. Normally the AND() function would be used in conjunction with a function such as =IF().

 =AND(Test1,Test2), like these 30 Tests can be done.


Here is the video tutorial of the same for clear understanding.

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at


Recent Posts

See All


bottom of page