How to use the AND Function in Excel:
The AND Function checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE. FALSE will be returned if any of the arguments are not TRUE.
In the below example, we will check to see if the values in columns A & B are greater than or equal to 100. We will place the formula in Column C cells
In this example, there are only 2 cells ( row 1 and 5) that show to be TRUE.
In cell C1 we have the following formula: =AND(A1>=100,B1>=100)
In cell C5 we have the following formula: =AND(A5>=100,B5>=100)
The above image shows how to fill in cell C1 with your arguments.