Summary
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
Purpose
To test the multiple conditions
Syntax
= AND ( logical1, logical2, … )
Arguments
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:
