How to Use AND Function in Excel


The Excel AND function is a logical function which required one or more than one condition at a same time. The AND function is use as the logical test inside the IF function to avoid extra nested IFs, and can be combined with the OR function. The AND function returns either TRUE or FALSE


To test the multiple conditions


= AND ( logical1, logical2, … )
and function in excel


logical1: The first logical value to evaluate
logical2: The second logical is optional to evaluate

Example Explanation

In above mentioned example, we have checked the two logic, if marks is greater than 33 and less than 50, then it should marked as TRUE otherwise FALSE. Formula used in C6 is:

AND Function with IF Function

You can use AND function inside the IF function. Using the above example, you can use AND as the logical_test for the IF function like:
if and function in excel
scroll to top