AND Function

Summary

The Excel AND function returns TRUE only when every logical test in the formula is TRUE. If even one test is FALSE, the result is FALSE.

AND is useful when a formula should approve something only after all required checks pass. Common examples include minimum score rules, eligibility checks, safe-range tests, and status formulas where partial success is not enough.

AND is most useful when several conditions all have to pass together. It helps keep rule-based formulas readable because the workbook can combine multiple checks into one clear TRUE/FALSE test instead of nesting the logic in a harder-to-follow way.

Syntax

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

Microsoft documents that AND accepts from 1 to 255 logical conditions. Each argument should evaluate to TRUE or FALSE.

Arguments

• logical1 - [required] The first logical test.
• logical2... - [optional] Additional logical tests.

These arguments can be direct logical values, comparisons such as A1>10, or references that already contain TRUE or FALSE.

AND vs Other Logical Functions

AND is easiest to understand when you compare it with the other core logical functions.

If your rule says "all of these must happen," AND is usually the right function. If the rule says "any one of these is enough," that is usually an OR formula instead.

Using AND

AND is often used as a gatekeeper inside IF. For example, a formula might return "Qualified" only if a person meets both a score requirement and a training requirement. Without AND, you would need to build that same logic with more complicated nested formulas.

AND is also very common in range checks. If a value must stay above a lower limit and below an upper limit at the same time, AND expresses that rule clearly. This is one of the most practical everyday uses of the function.

Microsoft notes that if an array or reference argument contains text or empty cells, those values are ignored. But if the specified range contains no logical values at all, AND returns #VALUE!. That matters most when you point AND at larger ranges or mixed data.

Example 1 - Require Two Passing Scores

This example checks whether two separate scores both reach the required level.

=AND(B2>=70,C2>=70)

The result is TRUE only if both scores are at least 70. If one score passes and the other does not, the result is still FALSE.

Example 2 - Check Whether a Value Is Inside a Range

AND is a simple way to test whether one number stays between two boundaries.

=AND(B2>=10,B2<=20)

This returns TRUE only when the value is 10 or greater and also 20 or less. That makes it a common pattern for allowed ranges and quality checks.

Example 3 - Trigger Only When Both Conditions Are Breached

Some alerts should appear only when multiple conditions fail together.

=AND(B2>100,C2>100)

This formula returns TRUE only when both values are above 100. It helps distinguish a full group problem from a one-sided issue.

Example 4 - Compare Results Against Multiple Targets

AND also works well with dynamic benchmark cells.

=AND(B2>=G2,C2>=H2,D2>=I2)

This returns TRUE only if every result meets its matching target. It is useful in scorecards, dashboards, and multi-step validation rules.

Conclusion Recap

AND is for rules where every condition must pass. In this lesson, that included passing two scores, staying inside a range, and meeting several targets at the same time.

If even one check fails, the result becomes FALSE. That is why AND is useful for strict requirements and validation rules.

• Summary: AND returns TRUE only when every test is TRUE.
• Best use: It is ideal for strict requirements where partial success should not count.
• Common pattern: Range checks such as "greater than this and less than that."
• Range behavior: Text and blanks inside array or reference arguments are ignored.
• Error note: If a referenced range contains no logical values, AND returns #VALUE!.
• Practical pairing: Combine AND with IF to return readable labels or decisions.