AND

The AND formula is used to perform a logical test and return TRUE if all of the tests are true, and FALSE if any of the tests are false. To use the AND formula, select the cell where you want the result to appear and enter “=AND(” followed by the logical tests separated by commas. For example, “=AND(A1>5,A2<10)" would return TRUE if the value in cell A1 is greater than 5 and the value in cell A2 is less than 10, and FALSE if either of those conditions is not true. Example:

Return TRUE if the value in cell A1 is greater than 5 and the value in cell A2 is less than 10: =AND(A1>5,A2<10).