Microsoft Excel Logical Function AND To perform logical operations:
- The AND Function/Formula performs logical tests for the given condition.
- It returns the true if all the given conditions are evaluate to true.
- It returns false if all conditions or parameters evaluate to false.
*It returns true if all the conditions/arguments evaluate to true
Syntax:
- Type the function =AND(
- Next enter the condition 1, condition 2, and more on as much as you want
- Complete ) the bracket and press enter
#Example 1: Perform logical test on single value - I do a logical operation using AND function and the arguments are to check whether the the selected value(here 250) is greater than 500 and is less than 200.
It will return false as follow:
#Example 2: Next I am changing the conditions - Now it will return true as both conditions evaluate to true as the amount 250 is greater than 200 and less than 300.
The result is:
#Example 3: Let's start with multiple values/arguments:
And, it return true 
You may find and learn more Excel Formulas here: