An Excel formula often returns FALSE because an IF function has no value specified for the condition that fails. Add a third argument to tell Excel what to return in that case; if the formula is not an IF, check whether it is deliberately returning a logical test or referring to a cell whose value is FALSE.
What FALSE means in an Excel cell
FALSE is a logical value in Excel, not just a word that happens to appear in a cell. Excel uses the two logical values TRUE and FALSE to represent the result of conditions, such as whether one number is greater than another. A formula can return one of these values intentionally, or another formula can pass it through to the cell you are looking at.
This matters because a displayed FALSE does not always mean that Excel has broken the formula. It may be the expected result of a comparison, or it may point to an incomplete formula that does not say what to do when a condition is untrue. The right fix depends on which of those situations applies.
For example, with the values to compare in A2 and B2, this formula returns TRUE if they match and FALSE if they do not: =A2=B2. That is a complete comparison formula. If you wanted a message instead, wrap the comparison in an IF function and specify a message for both outcomes.
Why IF returns FALSE when its condition fails
The IF function has three parts: a condition to test, a result when the condition is TRUE, and an optional result when it is FALSE. If you leave out that third part, Excel uses FALSE as the result when the condition fails. This is why a formula can appear to work for some rows and show FALSE in others: the TRUE case has a specified result, but the FALSE case does not.
With a number in A2, this formula displays High when A2 is greater than 100, but returns FALSE for 100 or less because no alternative result is supplied: =IF(A2>100,"High"). The missing argument is the common cause of the exact problem described in this question.
With the same layout, provide an explicit fallback value to cover both outcomes: =IF(A2>100,"High","Not high"). If A2 contains 85, the result is Not high; if it contains 125, the result is High. The fallback can be text, a number, a reference, or another formula, provided the result suits your task.
How to fix the formula step by step
Start by selecting the cell that shows FALSE and reading the formula in the formula bar. Look for an IF function with only a condition and a TRUE result. Then decide what should happen when the condition is false. Do not simply remove FALSE from view unless hiding it is genuinely the intended outcome; a clear fallback makes the worksheet easier to understand and check.
- Click the cell that displays FALSE and inspect its complete formula in the formula bar.
- Find the relevant
IFfunction and identify the condition and the result for the TRUE case. - Add the missing third argument after the TRUE result, separated by a comma.
- Press Enter and test the formula with an input that makes the condition TRUE and another that makes it FALSE.
- If the formula is copied down a column, check several rows, including boundary values such as exactly 100 when the test is greater than 100.
For a blank display instead of a label, with the test value in A2, use an empty text string as the false result: =IF(A2>100,"High",""). This returns High above 100 and an empty string otherwise. That is not the same as a truly empty cell: the formula remains in the cell, and functions that count or test cells can treat a formula returning an empty string differently from a cell that has never contained anything.
Check nested IF functions and copied formulas
A longer formula may contain multiple IF functions. Each one needs a result for the condition being tested and, unless its false result is intentionally omitted, an appropriate alternative. If a nested branch has no fallback, that branch can be the one that returns FALSE even though the rest of the formula looks complete. Read the parentheses from the inside out and match each condition to the results that follow it.
With a score in A2, this nested formula assigns A to 90 or above, B to 80 through 89, and Below B to scores under 80: =IF(A2>=90,"A",IF(A2>=80,"B","Below B")). If A2 contains 84, it returns B. The final text is the fallback for the second test; without that fallback, scores below 80 could produce FALSE.
When copying formulas, also check that cell references still point to the intended inputs. Relative references change as a formula is filled down, while references with dollar signs stay fixed. A reference shift may make a condition fail unexpectedly, although the FALSE itself still comes from what the formula says to return. Compare a row that works with one that does not before changing the formula for the entire range.
Other formulas that can legitimately return FALSE
A formula does not need an IF function to return FALSE. Comparisons such as equality, greater-than, and less-than tests produce logical results. Functions such as AND and OR also return TRUE or FALSE because their purpose is to evaluate conditions. If one of these expressions is the whole formula, a logical result may be exactly what Excel is designed to provide.
With a quantity in A2 and a minimum threshold in B2, this formula returns TRUE when the quantity meets the threshold and FALSE otherwise: =A2>=B2. To show a readable status instead, with the same cell layout, use: =IF(A2>=B2,"Meets minimum","Below minimum"). Choose a message only if the cell is meant to communicate a status; downstream formulas may need the original logical value.
A formula can also return FALSE because it references a cell that contains FALSE. That source cell might contain a comparison, a formula with an omitted false result, or an intentional logical value. Trace the references back to their source instead of editing the final cell blindly. In Microsoft 365 for Windows, select the formula cell and use Formulas > Trace Precedents to display cells that feed into it; remove the arrows with Formulas > Remove Arrows when finished.
FALSE, zero, blank, and text are not interchangeable
It is tempting to replace a FALSE result with zero or a blank, but those values have different meanings. FALSE is a logical value. Zero is numeric and can participate in arithmetic. An empty string is text with no visible characters. A genuinely empty cell contains no formula or value. Choose the result that matches how the rest of the workbook will use the cell.
- Use FALSE or TRUE when the cell represents a condition that another formula may test.
- Use 0 when the result is a quantity or amount and zero is a meaningful value.
- Use an empty text string when a formula result should look blank but the formula must remain in place.
- Use a clear label such as Not applicable when readers need to understand why there is no numeric result.
Formatting can change how a value looks, but it does not repair an incomplete condition. If you suspect the cell is displaying an unexpected value, click it and inspect the formula bar. Also check whether the formula itself contains a text string, refers to another cell, or evaluates a comparison. Do not assume a custom number format is the cause simply because the displayed result is surprising.
A reliable troubleshooting routine
Work from the formula outward: first establish what the formula returns, then verify its inputs and only then consider workbook settings. This helps distinguish a genuine FALSE result from a stale calculation or a formula that is being displayed rather than evaluated.
- Read the formula: Look for an omitted false result, a comparison used as the entire formula, or a reference to another cell.
- Check the inputs: Confirm that the referenced values are the values you expect. A number stored as text or an unexpected blank may affect a condition.
- Test both outcomes: Temporarily use one input that should meet the condition and one that should not. Restore the intended data afterward.
- Inspect calculation settings: On Windows, use Formulas > Calculation Options > Automatic if the workbook is set to Manual. Manual calculation can leave results out of date, though it does not explain an omitted fallback by itself.
- Check whether formulas are being shown: On Windows, Ctrl+` toggles Show Formulas. You can also use Formulas > Show Formulas. On Mac, use Formulas > Show Formulas if the shortcut differs on your keyboard or Excel version.
When a formula is complex, Formulas > Evaluate Formula can step through its calculation in Excel for Microsoft 365 on Windows. Use it to see which condition evaluates to FALSE and which branch supplies the final result. The feature is a diagnostic aid, not an automatic repair; you still need to decide what the formula should return for each case.
Prevent the same problem in future formulas
Before filling a formula down a worksheet, plan the expected result for both TRUE and FALSE cases. Writing the fallback explicitly makes the intent visible to anyone who reads the workbook later. If a blank is the desired outcome, use an empty string deliberately and document what that blank means where the distinction matters.
Test boundary values, not just typical examples. For a condition that checks whether a value is greater than 100, test 99, 100, and 101; exactly 100 is where a mistaken assumption about greater than versus greater than or equal to often appears. For formulas used in reports or calculations, confirm that the chosen fallback will not be mistaken for a numeric amount or a genuinely empty cell.
Finally, keep related logic readable. A long chain of nested conditions is harder to audit, and a missing result can be difficult to spot. Use clear labels, consistent references, and a small set of test cases so that each possible outcome is easy to verify before relying on the finished workbook.
Frequently Asked Questions
Why does my Excel IF formula show FALSE?
An IF formula returns FALSE when its condition is not met and the optional false-result argument has been left out. Add a third argument specifying what to return for that case.
How do I make Excel show a blank instead of FALSE?
With the condition value in A2, add an empty text string as the false result, for example: =IF(A2>100,"High",""). This looks blank when the condition is false, but the cell still contains a formula.
Why does a comparison formula return FALSE?
A comparison returns TRUE when its test is met and FALSE when it is not. Check the referenced values and the comparison operator; wrap the test in IF if you want a message rather than a logical value.
Does FALSE mean the formula has an error?
No. FALSE is a valid logical result, not an Excel error value. An incomplete IF may be the cause, but a comparison or another logical formula can return FALSE as intended.
Will IFERROR fix a FALSE result?
Usually not. IFERROR handles Excel error values, while FALSE is a valid logical value. Fix the missing false-result argument or revise the formula that is deliberately returning a logical result.
Related
- Excel Find Duplicates and Count Matching Values Easily
- Excel Find Defined Names: Name Manager, Scope, and Uses
- Excel File With Table Filters: How to Add and Use Them
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Average Ignoring Zeros: Formula and ExamplesTo calculate an average in Excel while ignoring zeros, use AVERAGEIF with the criterion “0″. If your values…
- Excel SUMIF Between Dates: Use SUMIFS CorrectlyTo sum values in Excel for dates between a start and end date, use SUMIFS with two conditions…
- Excel Subtotal Filtered Rows: Formula, Steps, and FixesYes. In Excel for Microsoft 365 on Windows, use the SUBTOTAL function to calculate from rows that remain…
- Excel Sum Range Based on Cell Value: SUMIF and MoreWith the values to test in A2:A7, amounts to add in B2:B7, and the requested category in D2,…
- Excel FILTER: What the Include Argument DoesIn Excel’s FILTER function, include is the test that decides which rows or columns to return: TRUE keeps…
- Excel Conditional Formatting: Use a Formula for RulesYes. In Excel, conditional formatting can use a formula that evaluates to TRUE or FALSE to decide which…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.