Excel AND Function

AND(logical1 [,logical2])

Returns the logical AND for any number of arguments.

logical1	The first logical value.
logical2	(Optional) The second logical value.

Remarks

* This function returns either True or False.
* This function will return True if all the logical arguments are True.
* This function will return False if all the logical arguments are False.
* The logical values can be constants, logical equations, cell references or named ranges.
* Any empty cells are ignored.
* If any argument does not evaluate to either True or False, then #VALUE! is returned.
* This function can be used to check if values meet certain criteria.
* You can have a maximum of 255 arguments.
* You can use the OR to return the logical OR for any number of arguments.
* You can use the NOT to return the opposite of a True or False value.
* You can use the XOR to return the logical exclusive OR for any number of arguments.
* For the Microsoft documentation refer to support.office.com.

	A	B
1	=AND(TRUE,TRUE) = True	5
2	=AND(TRUE,FALSE) = False	10
3	=AND(FALSE,TRUE) = False	some text
4	=AND({FALSE,FALSE}) = 0
5	=AND({TRUE},{FALSE}) = False
6	=AND(1,1) = True
7	=AND(0,0) = False
8	=AND(5<10,20>10) = True
9	=AND(10<5,10>20) = False
10	=AND(B1<=B2,20>=B2) = True
11	=AND(B3,TRUE) = True
12	=IF(AND(B1>0,B2<20),"yes","no") = yes
13	=AND(TRUE,"some text") = #VALUE!

Expand ...

1 - What is the logical AND for True and True.
2 - What is the logical AND for True and False.
3 - What is the logical AND for False and True.
4 - What is the logical AND for False and False submitted as two arrays.

Top