IF Number Is Between Two Numbers Excel

What this does

Checking whether a number falls inside a range needs two separate comparisons joined by AND(), because Excel formulas do not support the algebra shorthand "10 ≤ x ≤ 20" the way a math textbook does. Typing that shorthand directly as =IF(10<=A1<=20,...) is syntactically legal — it just means something completely different: Excel evaluates the leftmost comparison (10<=A1) first, producing a TRUE or FALSE, and then compares THAT boolean against 20. Because Excel ranks every logical value above every number for comparison purposes, a boolean is never <=20 — so the second comparison is always FALSE, and the whole formula always returns the FALSE branch, for every possible A1. It never errors, so this mistake ships silently into a live spreadsheet. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. Treat “if number is between two numbers excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected cells shows up while it is still harmless. When a formula is involved, keep the inputs labelled beside it, reference cells instead of typing values, and apply number formatting only after the result checks out. That turns a workflow that saves repeating the same clicks every week into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

A2 holds 15. =IF(AND(A2>=10,A2<=20),"Yes","No") correctly returns "Yes." The chained version =IF(10<=A2<=20,"Yes","No") returns "No" instead — even though 15 clearly sits between 10 and 20 — because 10<=A2 evaluates to TRUE first, and TRUE<=20 is FALSE (Excel treats TRUE as ranked above any number in a comparison), so the outer IF always takes the FALSE branch regardless of what A2 actually contains. "Between two numbers" reads like something a formula should handle in one comparison, and the syntactically-valid-but-wrong chained version is exactly the kind of mistake that passes a quick glance and then quietly poisons every downstream calculation that depends on it. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.

In Google Sheets

Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “if number is between two numbers excel”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.

Common mistakes

• Writing =IF(10<=A1<=20,...) expecting it to work like math notation — it runs without error but always evaluates to the FALSE branch, because the intermediate boolean result is never <=20 under Excel's comparison rules.
• Using OR() instead of AND() — OR(A1>=10,A1<=20) is TRUE for almost every number (anything above 10 OR below 20 covers nearly the whole number line), the opposite of a "between" test.
• Forgetting to decide whether the boundaries count as "inside" the range — >= and <= include them; > and < exclude them, and the two give different answers when A1 is exactly 10 or 20.
• Testing a blank or text cell against numeric boundaries and trusting the result without checking — a blank cell compares as 0 (correctly returning "No" for 10-20), but text can produce a misleading comparison instead of a clear error.

Frequently asked questions