Excel Functions

Excel AND Function

Pinterest LinkedIn Tumblr

The AND function is a logical function used to require more than one condition at the same time. AND returns either TRUE or FALSE. The AND function can be used as the logical test inside the IF function.

Purpose of Excel AND Function

Test multiple conditions with AND.

Return value

TRUE if all the conditions evaluate to TRUE, else it returns a FALSE.

Syntax

=AND (logical1, [logical2],….)

Arguments

ArgumentsDescriptionRemarks
logical1 An expression or reference to a cell containing an expression that represents some logical value, i.e.TRUE or False.Mandatory
[logical2]Additional expressions or references to cells containing expressions representing some logical values, i.e.TRUE or False. Optional

Usage notes

  • This function is not case-sensitive.
  • This function does not support wildcards.
  • Text values or empty cells supplied as arguments are ignored.
  • This function will return #VALUE if no logical values are found or created during evaluation.

Availability

Since 2007 for Windows.
Since 2011 for Mac.

Example

In the given example the return value will be TRUE if the score is less than 50 and 90 , FALSE if not matched with the given criteria.

AND Function

Thus here Deepika’s result is FALSE as her score is not less than 50 and 90. The formula used in this is =AND(C4<50,C4<90). The cell reference criteria given here is score column.

NOTE: Text values or empty cells supplied as arguments are ignored in AND function.

Suggested reading: 20 Excel Functions Useful For Finance Professionals

Related Posts

Write A Comment