Copyright

Using the AND function in Excel

Using the AND function in Excel
Coming up next: How to Filter Records and Data in Excel

You're on a roll. Keep up the good work!

Take Quiz Watch Next Lesson
 Replay
Your next lesson will play in 10 seconds
  • 0:03 What Is the 'AND' Function?
  • 1:57 Example
  • 4:07 Results
  • 5:21 Lesson Summary
Add to Add to Add to

Want to watch this again later?

Log in or sign up to add this lesson to a Custom Course.

Log in or Sign up

Timeline
Autoplay
Autoplay
Speed
Lesson Transcript
Instructor: Dr. Douglas Hawks

Douglas has two master's degrees (MPA & MBA) and is currently working on his PhD in Higher Education Administration.

Many commonly used functions in Excel are the simple-to-moderate mathematical functions. However, Excel also has text functions that significantly enhance the mathematical functions. In this lesson, we'll learn about the AND function.

What Is the 'AND' Function?

Excel is a very powerful data analytics tool. As organizations invest more in data analytics, Excel is becoming more powerful, with more functions, and working with more third-party applications. It's also moving from being a quantitative or numeric-focused spreadsheet to a database that includes logical functions, such as the AND function.

The AND function allows the Excel user to evaluate or test multiple conditions. In the syntax of Excel programming, whether it be as part of an IF-THEN statement or a conditional formatting command, the AND function can become a powerful part of a logical statement.

The AND function needs at least two arguments to assess. Those arguments can be as simple or complex as you'd like or need them to be. They are separated in the AND function by a comma, just like all of the arguments in Excel functions are. It provides either a 'true' or 'false' result based on the arguments inside the AND function.

Thus, for a very simple example, we could put =AND(3>2, 8=8) into an Excel cell and the answer would be TRUE. It's true because 3 is greater than 2 and 8 does equal 8. If we changed the last argument to 8=7, the answer to the formula would be FALSE, because while 3 is still greater than 2, 8 is not equal to 7, so both conditions are not true. Notice the syntax of the AND function; each term inside the parentheses is separated by a comma.

Example

The AND function can be very versatile and help in a number of ways. First of all, it's not limited to just two arguments. In fact, it can handle as many as 255. So, imagine you are a college administrator that has a scholarship funded by a private donor, but that donor was very specific with what kind of student should get the scholarship. In fact, the donor said they must be female, have at least a 3.5 grade point average, be a finance major, and be a graduate from one high school: North High School.

Now you have all of that information in your list of students, but it happens to be over 15,000 students long. You could try and sort it by a couple of the criteria, and then try to review the list to find the other two. Or, you could use the AND function, even though you need to match four criteria. To make this easy to read for anyone familiar with Excel, let's assume that gender is either male or female, and in column B; high school is either North High or something else, and in column C; selection of major is in column D; and GPA is in column E. Your list of 15,000 students starts on row 2, since the headings are in row 1.

To unlock this lesson you must be a Study.com Member.
Create your account

Register to view this lesson

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Try it risk-free for 30 days

Earning College Credit

Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it risk-free for 30 days!
Create an account
Support