Excel AND Function (Example + Sample File)

What is EXCEL AND FUNCTION

The Excel AND Function is listed under Microsoft Excel’s Logical Functions category. It returns a boolean value (TRUE or FALSE) after testing conditions you specify. In simple words, you can test multiple conditions with AND function and it returns TRUE if all those conditions are TRUE, else FALSE.

How to use it

To learn how to use AND function in Excel, you need to understand its syntax and arguments: 

Syntax

AND(logical1, [logical2], …)

Arguments

  • logical1: Condition which you want to verify.
  • [logical2]: Additional Conditions you want to verify.

Notes

  • Values will be ignored if the reference cell or array contained an empty cell or a text.
  • It will return an error if there is no logical value is returned that means the result of conditions should be in logical value (TRUE or FALSE).
  • The maximum number of values you can test is 255.

Example

To master AND function, we need to try it out in an example and below is one which you can try out:

In the below example, we have created a condition using IF function that if a student score 60 above marks in both of the subjects then only it will return TRUE else FALSE.

You can also use AND function to work with numbers as well.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

(Make sure to check out this Basic Excel Tutorial, this is a guide that will help you to get started with Excel, and after that, here we have a list of EXCEL‌ TIPS to make you an advanced Excel user in no time.)