Home » Excel Functions » Logical » Excel AND Function

Excel AND Function

Monday, November 30, 2015

1. AND Function
1.1. Syntax Function

AND (logical1, logical2, ...) : Returns TRUE if all arguments are TRUE, returns FALSE if one or more argument is FALSE
1.2. Example
Please try type below to your excel sheet and see result detail.

1.3. Explain
     About above example I will explain you reason why
   =AND(H9>100,I9<0) It mean that if cell H9 has value great than 100 also cell I9 has value less than 0 then result TRUE if one arguments is false then Result is FALSE.
1.4. Note
   - You can use and with other function like IF,.. more detail please continue read

Chia sẻ bài viết

Bài liên quan

Excel AND Function

Comments[ 0 ]