EXCEL logical functions : the AND function
The AND function , one of many EXCEL logical functions, is used to evaluate a number of logical conditions, passed as arguments to the function. The function will return a single value of TRUE or FALSE.
Syntax
AND(logical1, logical2 ………)
logical1 and logical2 are conditions that evaluate to TRUE or FALSE. The first argument is required the second one is optional.
You can have up to 30 arguments in EXCEL 2003 and 255 in EXCEL 2007.
Examples:
Cell A1 = 6
Cell B1 = 10
Cell C1 :
=AND(A1>5;B1>10) : returns FALSE.
=AND(A1>5;B1=10): returns TRUE.
=AND(A1>5;B1>5): returns TRUE.
You can nest the AND function within another logical function as follows:
=IF(AND(A1>5;B1>10) ;”Valid Range”;”Invalid Range”)
If you put this formula in C1 for example, and A1 and B1 have the values shown above, then C1 will have the value : “Invalid Range”, because the AND function will evaluate to FALSE.
