The AND function of Excel is used to compare more than one logical condition. Up to 255 conditions can be compared at a time, which is provided as arguments. Each argument must return True or False or a value that can be treated as True or False. The purpose of AND function can be understood for the example: if A1 contains the number 60, then: =AND(A1>0,A1>10,A10,A1>10,A10,A10,A180,OR(B1="Under Review",B1="In Process")) The formula will return True when A1>80 and B1 is "Under Review" or "In Process": Notes Wildcards cannot be used with the AND function. It is not case-sensitive. Text or empty cells is argument is ignored. The AND function returns #VALUE if no logical arguments are found.