AND (condition1, condition2, ...)

Description:

This function returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE.

The AND operand is used to combine conditions and check for them all being true or them all being false.

Syntax: AND (Condition1 , Condition2....n)

• Condition 1 to n: Condition 1 to n, ... are 1 to 30 conditions you want to test that can be either TRUE or FALSE.

Remarks

• The arguments must evaluate to logical values such as TRUE or FALSE, or the arguments must be references that contain logical values.
• If a reference argument contains text or empty cells, those values are ignored.
• If the specified range contains no logical values, AND returns the #VALUE! error value.

Example

=IF ( AND (NUM1<NUM2 ,NUM2<NUM3),  "Message1", "Message2" )

 

this example returns the statement, "Message1" if all the test conditions that are joined together by the "AND" operand,  return the value "True". If one or more than one of the conditions in the formula statement return a value "False" then the "AND" operand forces the function to go to the "if false expression". Execution statement, in the IF condition. In this case, the message that will be returned is "Message2" if one or more conditions are found to be false. Num1 and Num2 are member names, and in a real world example they will need to be referenced completely (with dimension and cube names).