AI Excel Generator
← ALL GUIDES

Excel IF AND Formula: Test Multiple Conditions in One Formula

Updated November 4, 2026 · AI Excel Generator

The Excel IF AND formula lets you return one result when several conditions are true and another when they are not.

A few small examples show how to combine checks for numbers, text, dates, and blank cells without making the formula hard to read.

How the IF AND formula works

IF evaluates a logical test and returns one value when the test is true and another when it is false.

AND checks multiple logical tests and returns TRUE only when every test is true.

Nesting AND inside IF makes the combined result the decision rule.

The general syntax is:

=IF(AND(logical_test1, logical_test2), value_if_true, value_if_false)

For example, suppose cells A2 and B2 contain a sales total and a number of completed orders.

This formula marks the row as eligible only when sales are at least $500 and the order count is at least 10:

=IF(AND(A2>=500, B2>=10), "Eligible", "Not eligible")

If A2 is 650 and B2 is 12, the result is Eligible.

If either value is below its threshold, the result is Not eligible.

The comma-separated arguments are used in Excel installations with comma list separators; some regional settings require semicolons instead.

Use IF AND with numbers and text

You can combine comparisons that check different kinds of data.

Imagine a worksheet with a product category in A2 and its price in B2.

To flag discounted accessories costing more than $20, use:

=IF(AND(A2="Accessory", B2>20), "Review discount", "No action")

Both conditions must match for the formula to return Review discount.

Text values in formulas should be enclosed in straight quotation marks.

Excel’s standard equality comparison for text is not case-sensitive, so Accessory and ACCESSORY generally match.

For a case-sensitive comparison, use EXACT as a test inside AND:

=IF(AND(EXACT(A2, "Accessory"), B2>20), "Review discount", "No action")

Use cell references for values that may change, such as thresholds stored in D1 and E1.

For example, =IF(AND(A2>=$D$1, B2>=$E$1), "Eligible", "Not eligible") keeps the thresholds fixed when you fill the formula down.

The dollar signs make those references absolute.

Check date ranges with IF and AND

Excel stores dates as serial numbers, which means date comparisons use the same operators as numeric comparisons.

If C2 contains a delivery date, this formula checks whether it falls within the first quarter of 2026, including both boundary dates:

=IF(AND(C2>=DATE(2026,1,1), C2<=DATE(2026,3,31)), "Q1", "Outside Q1")

DATE constructs a date from its year, month, and day, avoiding ambiguity between regional date formats.

A date stored as text may not compare as expected.

If the result seems wrong, check whether the cell contains a real Excel date value rather than text that merely looks like a date.

If C2 may also contain a time, the upper-bound comparison to March 31 can exclude entries later that day because the stored value includes a time fraction.

A robust way to include all of March 31 is to use an exclusive boundary at April 1:

=IF(AND(C2>=DATE(2026,1,1), C2<DATE(2026,4,1)), "Q1", "Outside Q1")

This pattern includes every time on March 31 while excluding midnight on April 1.

Combine AND with blank-cell checks

Blank or incomplete rows need deliberate handling.

Suppose A2 contains a student name and B2 contains a score.

To show a pass only when a name is entered and the score is at least 70, use:

=IF(AND(A2<>"", B2>=70), "Pass", "Check entry")

The test A2<>"" checks that A2 is not empty.

A formula that returns an empty string can also appear blank to this test.

If B2 is empty, Excel may treat it like zero in a numeric comparison, so the example returns Check entry.

If you need to distinguish a missing score from a score of zero, test both cells explicitly:

=IF(AND(A2<>"", B2<>"", B2>=70), "Pass", "Check entry")

When imported data may contain spaces, a cell can look empty while still holding characters.

TRIM removes leading, trailing, and repeated ordinary spaces, but nonbreaking spaces from copied web content may need separate cleanup.

Use more than two conditions

AND accepts many logical tests, so it can check several requirements at once.

This example approves a request only if the amount in B2 is between 100 and 1,000, the status in C2 is Approved, and the region in D2 is North:

=IF(AND(B2>=100, B2<=1000, C2="Approved", D2="North"), "Process", "Hold")

For numeric ranges, including both endpoints requires >= and <=.

Use > or < when an endpoint should not qualify.

Keep each condition readable by placing the formula on multiple lines in the formula bar or using line breaks while editing; Excel stores the logic as one formula.

For many conditions, a long formula becomes difficult to maintain.

Consider placing thresholds or allowed values in cells, using a lookup table, or splitting the decision into helper columns.

Those approaches make later changes easier to review than editing a long chain of hard-coded tests.

Common errors and compatibility notes

  • Every AND condition must be true. If one test fails, AND returns FALSE and IF uses its false result.

    Use OR instead when any one condition should be enough.
  • Use matching separators. Most English-language examples use commas, but some regional configurations use semicolons between function arguments.

    Follow the separator Excel accepts in your workbook.
  • Check data types. Numbers saved as text and dates saved as text can make comparisons behave unexpectedly.

    Convert or clean imported values where needed.
  • Handle errors intentionally. An error in a referenced cell can pass through the logical test and appear in the formula result.

    If error values are possible, consider whether to handle them with IFERROR or a dedicated error check.
  • Use a formula version supported by the spreadsheet app. IF, AND, and DATE are available in current desktop Excel, Excel for the web, and Google Sheets.

    These functions also exist in older Excel versions, though menu labels and some surrounding features can differ.

When a formula returns the unexpected branch, evaluate each condition separately in empty cells.

For example, enter =A2>=500 and =B2>=10 to see which test is FALSE, then check the underlying values and cell formats.

This isolates comparison problems before you inspect the complete nested formula.