Table of Contents
Summary
The Excel AND function tests whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. If any argument is FALSE the AND function will return FALSE.
The AND function is an Excel logical function.
Formula
=AND(logical1, [logical2], [logical3], …)
Arguments (inputs)
logical1 = a logical statement to be tested that can either be TRUE or FALSE and can be logical values, arrays, or references
logical2, logical3, … = [optional] a logical statement to be tested that can either be TRUE or FALSE and can be logical values, arrays, or references
Return value
The AND formula will return a result of TRUE or FALSE. If all arguments are TRUE then TRUE will be returned however if any arguments are FALSE then FALSE will be returned.
Example
In the example above the AND formulas in column H test whether the order totals in column F are greater than 1000 and if the sales representative is “Jones”.
=AND(F10>1000, C10=”Jones”)
Because the value in cell F10 is $1,500 and the sales representative in cell C10 is “Jones”, the AND formula returns TRUE in cell H10.
