AND

Checks if all the logical tests are TRUE

Syntax of Excel And formula:
=AND(logical1,[logical2],…)

In words:
=Check if (this logic 1, AND this logic 2, AND any other logic) are all TRUE then return TRUE

Explanation

AND function is mostly in conjunction with IF function to perform logical tests. AND function allows the use of multiple conditions. As mentioned earlier AND function confirms if all of the logical conditions hold true. Result is TRUE if all conditions are fulfilled.

Examples of Excel And formula

=AND(2+2=4,3-3=0) will result in TRUE

=IF(AND(H7-$C5<=60,H7-$C5>30),$D5,0)
This fromula is checking for two conditions:

  1. H7-C5 <=60
  2. H7-C5>30

If both of the above conditions are fulfilled then value in cell D5 will be fetched otherwise zero will be inserted.