AND function

This function will return TRUE if all arguments are TRUE and FALSE otherwise.

 

Syntax

 

AND(Expression1, Expression2, Expression3, … )

  • Expression1 (required) – This is an expression that can evaluate to either TRUE or FALSE.
  • Expression2, Expression3 etc… (optional) – These are additional expressions you want to test.

 

Example

 

In this example we test two expressions. As seen, the result is only true when both expressions evaluated are true.

 

=AND(A2,B2)

 

AND

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Related Posts

IFNA function

This function will return a specified value if your given expression results...

read more

TRUE function

This function will return the TRUE value. This is the same as just entering...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃