AND

Rational

Return TRUE if all its arguments are correct.

Description

The Excel AND function is a logical operator that join two or more criteria and return TRUE that satisfy all given criteria.
For example, If A2 is 75 and we enter formula =AND(A2>1,A2<50), result display “FALSE” as the value A2 does not meet both criteria.

Syntax

=AND(logical1, [logical2], …)

Parameters

logical1 -The first criteria to evaluate
logical2 [optional] – Additional criteria to test.

Return Value

TRUE if satisfy all criteria. Otherwise, it returns FALSE

Key Notes

• The AND function return TRUE only if all the given logic fulfills its condition; the function can accept a maximum of 255 logic.
• Use OR Function returns TRUE when at least one of the logic is true
• AND function is a logical operator which comprehend a logical test in term of TRUE or FALSE.
• Values like text or empty cells are ignored in the argument.

To join both criteria and show text like here in cells B8 and C8 we have digit  1 and 100 and we put formula =IF(AND(75>B8 ,75<C8),”In Range”,”Out of Range”) it return In Range. As both criteria is True so, it show text In Range other than it show Out of Range.

SWITCH

The Excel SWITCH function lookup value in a list of multiple labels and return the corresponding first match otherwise default clause or #N/A return.

XOR

The XOR function returns TRUE when only one of the logic or condition is true. It returns TRUE if only one is right, not ‘at least one’ like OR function.

OR

The OR function is a logical operator that returns TRUE if the condition matches i.e. =OR(A1=10, A1=100) check cell A1 contains either 10 or 100.