Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to combine IF and AND in Excel and Google Sheets
Topic:IF, IFS & nested conditionsExcel & Google Sheets
=IF(AND(A2>0,B2>0),"Both Positive","Not Both Positive")✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value A | Value B | Result |
| 5 | 10 | |
| -3 | 8 | |
| 7 | -2 | |
| 4 | 6 |
=IF(AND(A2>0,B2>0),"Both Positive","Not Both Positive")→Both Positive
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Write all conditions you need to be simultaneously true as arguments inside AND(): AND(condition1, condition2, …).
- 2Use the AND() as the logical_test of IF: =IF(AND(A2>0,B2>0),"Both Positive","Not Both Positive").
- 3Press Enter. The formula returns the first value only when every AND condition is TRUE; otherwise it returns the else value.
Tips
- For readability, break complex multi-condition formulas onto multiple lines in the formula bar using Alt+Enter (Windows) or Ctrl+Option+Return (Mac).
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can I use IF AND to check text as well as numbers?
Yes. Conditions work with text, numbers, or dates: AND(A2="Yes",B2>100,C2<>"Exclude") is perfectly valid.
What happens if one of the cells in an AND condition is empty?
An empty cell evaluates to 0 or FALSE depending on context. A condition like A2>0 will be FALSE for an empty cell.
More on IF, IFS & nested conditions
See all →How-to
How to hide #N/A and other formula errors
Replace #N/A, #DIV/0!, and other errors with a blank or a friendly message using IFERROR or IFNA. Works in Excel and Google Sheets.
Error fixFix Nested IF
Nested IF formulas not working in Excel and Google Sheets — fix bracket mismatches, wrong evaluation order, overlapping conditions, and the 64-nesting limit.
How-toHow to sum if a cell contains specific text
Use SUMIF with wildcard criteria (*text*) to sum values in a column whenever a related column contains a specific substring.
How-toHow to write a nested IF formula
Chain multiple IF functions inside each other to test several conditions and return different results for each scenario.
How-toHow to write an IF with multiple conditions
Combine IF with AND or OR to test multiple conditions simultaneously and return a result based on whether all or any are true.
How-toHow to combine IF and OR
Use IF with OR to return a value when at least one of several conditions is true in Excel or Google Sheets.