## Quick Intro

By using AND Function you can check multiple conditions at a time.

If all those conditions are TRUE it will return TRUE and if any of those conditions is not TRUE then it will return a FALSE.

In simple words, it will only return TRUE when all conditions are TRUE else it will return FALSE.

In above example, I have used And Function to check 3 conditions in a single formula. Where all these 3 conditions are met, it has return TRUE and where all the conditions are not met, the result is FALSE.

## Syntax

AND(logical1, [logical2], …)

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

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

## Examples

The best use of AND is with IF Function. By combining these two functions you can increase the powers of IF Function.

In above example, I have used both functions to get a message if both of the conditions are met. You can also create more dynamic functions to make best out of this function.

## What’s Next?

To learn more about Excel AND Functions you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There are also you have OR | NOT  functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples for you.

• David González

Exactly, you can use … =if(or(a=b;b=c;c=x);true;false) or =if(and(a=b;b=c;c=x);true;false)

• Puneet Gogia

Right David.