AND function: Description, Usage, Syntax, Examples and Explanation

What is AND function in Excel?

AND function is one of the Logical functions in Microsoft Excel that is used to determine if all conditions in a test are TRUE.

Here are some general examples of using AND by itself, and in conjunction with the IF function.

Formula	Description
=AND(A2>1,A2<100)	Displays TRUE if A2 is greater than 1 AND less than 100, otherwise it displays FALSE.
=IF(AND(A2<A3,A2<100),A2,”The value is out of range”)	Displays the value in cell A2 if it’s less than A3 AND less than 100, otherwise it displays the message “The value is out of range”.
=IF(AND(A3>1,A3<100),A3,”The value is out of range”)	Displays the value in cell A3 if it is greater than 1 AND less than 100, otherwise it displays a message. You can substitute any message of your choice.

For more example visit: