AND
Checks if all the logical tests are TRUE
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
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.
=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:
If both of the above conditions are fulfilled then value in cell D5 will be fetched otherwise zero will be inserted.