Quick answer
The IF AND formula returns one result only when all listed conditions are true.
=IF(AND(B2>=1000,C2="Approved"),"Pay","Hold")Syntax
Use this syntax as the pattern, then replace the sample arguments with your own cells, ranges, and criteria.
=IF(AND(condition1, condition2), value_if_true, value_if_false)When to use it
Logical formulas help a spreadsheet make decisions. They are useful when a report needs to say whether a target was met, whether a row needs attention, or which label should be shown based on one or more conditions.
- Mark invoices as paid or overdue
- Create pass/fail labels for scores
- Flag rows that need review
- Build status messages for dashboards
Example worksheet layout
Test the formula in a small worksheet first. This makes it easier to confirm the result before copying the formula down hundreds of rows.
| Column or range | What it represents |
|---|---|
| A | Item, person, or transaction |
| B | Score / status / amount |
| C | Formula result or decision label |
Copy-paste examples
These examples move from simple to more practical versions. Start with the beginner examples, confirm the result, then adapt the intermediate and advanced versions.
Basic IF AND example
=IF(AND(B2>=1000,C2="Approved"),"Pay","Hold")Start with one row so you can confirm the logic before copying down.
Return a blank until the row is ready
=IF(A2="","",IF(AND(B2>=1000,C2="Approved"),"Pay","Hold"))Keep unfinished rows from showing confusing results.
Use the formula with a fixed target
=IF(AND(B2>=${H}$20,C2="Approved"),"Pay","Hold")Lock the target cell when every row compares to the same input.
Use with a table column
=IF(AND([@Value]>=1000,[@Status]="Approved"),"Pay","Hold")Structured references are easier to read in Excel Tables.
Make the output report-friendly
=IFERROR(IF(AND(B2>=1000,C2="Approved"),"Pay","Hold"),"Check row")Show a clear message instead of letting the dashboard display an error.
Combine with LET for readability
=LET(result,IF(AND(B2>=1000,C2="Approved"),"Pay","Hold"),result)Use LET when the final formula will become long.
How to use it step by step
- Put your raw data in clear columns with headers such as Amount, Date, Status, Region, or Customer.
- Paste the starting formula into the first result cell, usually row 2.
- Replace sample references such as A2, B2, or $F$2:$F$100 with the cells in your own worksheet.
- Check the result on a few rows where you already know the expected answer.
- Copy the formula down only after the first row returns the right result.
Common mistakes and fixes
- Text outputs are missing quotation marks.
- Rules overlap, so a later condition never has a chance to apply.
- Fixed thresholds are not locked with dollar signs before copying down.
- Test the formula on a few known rows before using it across a full report.
Beginner tips
- Use a small sample first so you can see exactly how the IF AND formula behaves.
- Convert your source range into an Excel Table when the data will grow over time.
- Add a short note near important formulas so future users know what each input represents.