IF AND Formula

What this does

The IF/AND combination tests whether all of a set of conditions are simultaneously true before returning a result. AND() returns TRUE only when every argument inside it evaluates to TRUE; wrapping it in IF() lets you branch on that combined result. This is the standard Excel pattern for "only if all criteria are met" logic — approving a loan when credit score AND income both exceed thresholds, flagging a row only when two columns both match, or applying a discount when a customer AND their order both qualify. AND() accepts up to 255 arguments, so you can stack many conditions without nesting. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “if and formula”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

Scenario: you want to flag rows where both column A (quantity) and column B (price) are greater than zero — meaning the row has a real sale. Enter =IF(AND(A1>0,B1>0),"Yes","No") in C1. If A1=5 and B1=12, AND(5>0,12>0) evaluates to TRUE, so IF returns "Yes". If A1=0 and B1=12, AND evaluates to FALSE (because 0>0 is FALSE), so IF returns "No". Copy the formula down column C. To extend: =IF(AND(A1>0,B1>0,C1<>"Cancelled"),"Valid","Invalid") adds a third condition. Use IF/AND whenever the positive outcome requires every criterion to be satisfied. It is cleaner and more readable than an equivalent nested IF chain, and it evaluates all conditions in a single pass. Colleagues can scan =IF(AND(A1>0,B1>0,C1="Active"),"Yes","No") instantly; the same logic in nested IFs takes three levels of brackets to say the same thing. Check the referenced cells, argument order and result type in your workbook. Start with the worked example before changing an input, then compare the changed result with the calculation you expected. An error value or a result of a different type is a reason to inspect the inputs and arguments.

In Google Sheets

The standard worksheet functions used by this example are listed in Google Sheets. Check the cell references, argument separators and input types in the target spreadsheet, then compare the worked result. This formula-availability check does not establish identical menus, keyboard shortcuts or workbook features, and it is not a product execution test. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. For “if and formula”, keep the input cells and the result visible while you check the formula in Excel. Follow the worked example and change one input at a time. The steps explain the workbook calculation; this page does not run a live calculator for that task.

Common mistakes

• Confusing AND with nested IF — AND(A1>0,B1>0) tests both conditions at once; IF(A1>0,IF(B1>0,…)) tests them sequentially. Both are correct but AND is more readable for simultaneous criteria.
• Using AND outside IF — AND() returns TRUE or FALSE, which Excel displays as the text "TRUE"/"FALSE" in a cell. Wrap it in IF to return a more meaningful result.
• Forgetting that AND returns FALSE if ANY argument is FALSE — if you need "at least one true", use OR() instead.

Frequently asked questions