Use the AND function to test multiple conditions at the same time, up to 255 conditions. Each logical condition (logical1, logical2, etc.) must evaluate to TRUE or FALSE, or be arrays or references that contain logical values.
For example, to test if the value in A1 is greater than 0 and less than 5, use the following formula:
It can be useful to extend the functionality of functions like IF with AND. Using the above example, you can supply AND as the logical_test for the IF function like so:
=IF(AND(A1>0,A1<5), "Approved", "Denied")
This formula will return "Approved" only if the value in A1 is greater than 0 and less than 5.