Returns the logical value TRUE or Yes if all of the arguments evaluate to TRUE; returns FALSE or No if one or more arguments evaluate to FALSE.

Syntax

AND(logical1,logical2,…)

Logical1,Logical2,…    are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

Remarks

  • The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be column references that contain logical values.

  • If a column reference argument contains text, AND returns the #VALUE! Error value; if it is empty, it returns FALSE.

  • If the arguments contain no logical values, AND returns the #VALUE! error value.

  • If one or more arguments contain #NULL!, AND returns #NULL!.

Example 1

Formula

Description (Result)

=AND(TRUE,TRUE)

All arguments are TRUE (Yes)

=AND(TRUE,FALSE)

One argument is FALSE (No)

=AND(2+2=4,2+3=5)

All arguments evaluate to TRUE (Yes)

=AND(TRUE,#NULL!)

One argument contains #NULL!(#NULL!)

Example 2

Col1

Col2

Formula

Description (Result)

50

104

=AND(1<[Col1], [Col1]<100)

Because 50 is between 1 and 100 (Yes)

50

104

=IF(AND(1<[Col2], [Col2]<100),

Displays the second number, if it is between 1 and 100, otherwise displays a message (The value is out of range.)

50

104

=IF(AND(1<[Col1], [Col1]<100), [Col1], "The value is out of range.")

Displays the first number, if it is between 1 and 100, otherwise displays a message (50)

Top of Page

Need more help?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×