AND « Logical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Logical functions
  3. AND
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,