AND(logical1,logical2, ...) returns TRUE if all of its arguments are TRUE : AND « Logical functions « Microsoft Office Excel 2007 Tutorial






Input the formula: =AND(TRUE, TRUE). Press Enter to get the result.
Input the formula: =AND(TRUE, TRUE)
18.1.AND
18.1.1.AND(logical1,logical2, ...) returns TRUE if all of its arguments are TRUEAND(logical1,logical2, ...) returns TRUE if all of its arguments are TRUE
18.1.2.=AND(2+2=4, 2+3=5)=AND(2+2=4, 2+3=5)
18.1.3.=AND(1=AND(1<A2, A2<100)
18.1.4.=IF(AND(1=IF(AND(1<A3, A3<100), A3,