You want to check two conditions with Excel IF function? You’ve come to the right place. IF is one of Excel’s most popular and versatile functions. But things get exciting when you start combining it with multiple conditions — especially using AND, OR, nested IFs, and even blending it with SUMIFS.In this article, let me show you how to write IF formulas with a real-life example using a sales dataset, depicted below. Click here to download the data file.Example 1: Excel IF Statement Two Conditions Using ANDScenario: You want to check if a sale happened in the North region and if the revenue is more than 2000.=IF(AND(G4>2000, C4="North"), "Yes", "No")What this does: If both conditions are true, it says “Yes”. If even one fails, you get “No”.This is perfect for filtering VIP-level sales in specific territories.Example 2: IF with Date ConditionScenario: You want to see if the salesperson is Bob and the sale happened before April 15, 2025.=IF(AND(D4="Bob", B4 3000 and units sold > 35 ? 5% bonusOtherwise ? 3% bonus=IF(AND(G4>3000, F4>35), 5%, 3%) * G4This is a very common use-case: checking two values to decide payout level.Example 4: Multiple OR Conditions Inside IFScenario: Approve if either region is North or South, and salesperson is either Alice or Bob.=IF(AND(OR(C4="North", C4="South"), OR(D4="Alice", D4="Bob")), "YES", "NO")? Combine AND and OR when you need multiple “paths” to approval.Example 5: Categorizing Using Nested IFs and BetweenScenario: Label accounts based on revenue:Over 4500 ? “Major Account”Between 3000 and 4500 ? “Key Account”Else ? “Normal Account”=IF(G4>4500, "Major Account", IF(AND(G4>=3000, G4 and set up the rule based on the behavior you want. (For example, highlight cells -> Greater than is perfect for the above example)Specify the input and formatClick ok to have the rule “dynamically applied” to your dataYou can add more complex and multiple condition rules too. Refer to my conditional formatting basics page for a proper tutorial.A Few More Handy PatternsHere are a few more patterns you can experiment with:Check for blank cells:=IF(ISBLANK(D4), "Missing", "Present")Combine IF with SEARCH (for partial matches):2500, F4>=25, C4="North"), "Qualified", "Nope")" style="color:#D4D4D4;display:none" aria-label="Copy" class="code-block-pro-copy-button">=IF(AND(G4>2500, F4>=25, C4="North"), "Qualified", "Nope")Then you can filter or pivot based on IsQualified.Final ThoughtsCombining IF with AND, OR, and nesting gives you powerful logic control — without writing code. Start with two conditions, then try combining patterns as shown here.Want to go further? Try writing a formula that combines:Multiple date checksRegion + product filtersRevenue thresholdsLet Excel do the thinking for you!Additional Resources for youRefer to below pages for more help on IF conditions with Excel.10 Advanced IF tricks you must know (or watch this video)How to use SUMIFS to add up data that meets one or more conditionsReplacing long, nested IF functions with CHOOSE formulaBETWEEEN Formula in ExcelConditional formatting – Highlight IF rules are metIF challenges for you:Can you vote in Sumeria?Blood pressure categorizationCheck if both dates are in the same month?The post Excel IF Statement Two Conditions appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.