If an Excel TRUE/FALSE formula is not working, first check that it starts with =, that its cell references and comparison are correct, and that the result is a logical value rather than text. Then check for mismatched data types, hidden spaces, or manual calculation mode; these are common reasons a formula returns an unexpected result or appears not to update.
What a TRUE or FALSE result means in Excel
Excel uses the logical values TRUE and FALSE to represent whether a condition is met. A comparison such as whether one value is greater than another evaluates to one of these values. The result may appear in a cell as TRUE or FALSE without quotation marks, but it is not the same as the text string “TRUE” or “FALSE”. That distinction matters when another formula, an imported dataset, or a report depends on the result.
For a simple check, with a number in A2 and a number in B2, enter =A2=B2. The result is TRUE when the two cell values are equal and FALSE when they are not. The equals sign at the start tells Excel to calculate a formula; the second equals sign is the comparison operator. If you type A2=B2 without the first equals sign, Excel will not evaluate it as a normal formula.
You do not need to wrap a comparison in an IF function just to display TRUE or FALSE. A comparison already returns a logical result. IF is useful when you want a different output, such as a word, a number, or a blank, depending on whether the condition is met.
Check the formula and its cell references
Start by selecting the result cell and inspecting the formula bar. Confirm that the formula begins with an equals sign and refers to the intended cells. A formula can be syntactically valid yet give the wrong answer because it compares the wrong row, column, or range. This often happens after copying a formula down a column or inserting cells.
For example, with a status in A2 and an expected status in B2, =A2=B2 compares those two cells in the current row. If you copy the formula to row 3, Excel normally adjusts the references to A3 and B3. If you meant to compare every row against one fixed cell, use an absolute reference for that cell. With the expected status stored in B1 and the row’s status in A2, =A2=$B$1 returns TRUE when the values match and FALSE otherwise; the dollar signs keep B1 fixed when the formula is copied.
- Click the formula cell and check whether the referenced cells contain the values you expect.
- Look for a shifted row number, an incorrect column letter, or a reference to a blank cell.
- When copying formulas, decide whether references should move or stay fixed; use dollar signs for references that must stay fixed.
- If the formula is visibly displayed in the cell rather than its result, check whether the cell is formatted as Text or whether Show Formulas is on.
If the cell is formatted as Text, change its number format to General using Home > Number Format > General, then re-enter the formula. Merely changing the format may not make an existing text entry calculate; select the cell, press F2, and then press Enter to make Excel parse it again. If many cells have the same problem, select the affected range and use the same format-and-re-enter approach carefully.
Logical values are not the same as text
A frequent source of confusion is data imported from a CSV, copied from a website, or produced by another program. A cell may contain the text TRUE even though it looks like Excel’s logical TRUE. A comparison between a logical value and text can return FALSE, and functions that expect numbers or logical values may treat text differently.
With a suspected logical value in A2, =A2=TRUE returns TRUE if A2 contains the logical value TRUE and FALSE if it does not. If A2 contains the literal text TRUE, the comparison is generally FALSE because the types differ. If you specifically need to test for that text, with the text in A2, =A2="TRUE" compares it to the text string and returns TRUE when the characters match exactly. The quotation marks in the formula identify text; they do not turn the result into a text value.
To tell whether Excel sees a cell as a number, text, or logical value, inspect the source and try a type-checking function. With the value being checked in A2, =ISNUMBER(A2) returns TRUE for a numeric value and FALSE for text or a logical value. This does not convert anything; it helps identify why a comparison behaves unexpectedly. For a text number such as “10”, conversion may be needed before numeric comparisons make sense.
Look for spaces, inconsistent text, and case
Text comparisons can fail because values that look alike are not actually identical. An extra leading or trailing space, a nonbreaking space copied from a web page, or a different punctuation mark can make two labels unequal. For instance, “Paid” and “Paid ” look similar but contain different characters. Check the original data, especially when the values were pasted or imported.
For a basic cleanup, with the text to clean in A2, =TRIM(A2) removes ordinary leading and trailing spaces and reduces repeated spaces between words to single spaces. It does not remove every unusual whitespace character, including some nonbreaking spaces. If that is the issue, the source may need a more targeted cleanup before you compare it.
Excel’s ordinary text comparisons are not case-sensitive: “paid” and “Paid” generally compare as equal. If capitalization must match, with the two text values in A2 and B2, =EXACT(A2,B2) returns TRUE only when the text matches character by character, including letter case. EXACT does not ignore extra spaces, so clean the values first if spaces are also a concern.
Use AND, OR, and IF for combined conditions
When a result depends on more than one test, AND and OR combine logical conditions. AND returns TRUE only if all its conditions are TRUE; OR returns TRUE if at least one condition is TRUE. IF then lets you return a chosen value based on a condition. In Excel for Microsoft 365 on Windows, formulas use commas between arguments by default, though regional settings can require semicolons instead.
With a payment status in A2 and an amount in B2, =AND(A2="Paid",B2>=100) returns TRUE only when the status is Paid and the amount is at least 100. If either condition fails, the result is FALSE. With the same layout, =IF(AND(A2="Paid",B2>=100),"Eligible","Check") returns Eligible when both tests pass and Check otherwise. The text results are enclosed in straight double quotation marks.
For a single condition, IF can be unnecessary if the desired output is simply TRUE or FALSE. With a score in A2, =A2>=60 already returns TRUE for 60 or higher and FALSE for a lower value. Adding IF around that test with TRUE and FALSE as the outcomes does not change the logic, so use the shorter comparison unless you need custom outputs.
Check errors and unexpected blanks
A formula cannot produce a useful TRUE/FALSE answer if one of its inputs already contains an error such as #N/A or #VALUE!. The error may originate several cells away, so inspect the referenced cells and trace the calculation rather than assuming the comparison operator is at fault. Excel’s Formulas tab includes formula-auditing tools such as Trace Precedents, which can help show which cells feed the selected formula.
With potentially error-producing values in A2 and B2, =IFERROR(A2=B2,FALSE) returns FALSE if the comparison encounters an error. Use this only when treating every error as FALSE is appropriate; it can hide a genuine data problem that deserves correction. In a quality-check worksheet, it may be better to find and fix the source error than to suppress it.
A blank cell can also lead to a result that surprises you. If the formula compares a blank to zero or to empty text, Excel’s comparison and coercion rules may affect the outcome. Check whether the cells are genuinely blank, contain a formula returning an empty string, or contain a space. These can look identical on the worksheet but are different underlying values.
Make sure Excel is recalculating
If a formula’s result does not change after you edit its inputs, the workbook may be using manual calculation. In Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and select Automatic. You can also use Formulas > Calculate Now to recalculate the workbook. In Excel for Mac, the calculation options are on the Formulas tab as well, though the ribbon layout can vary slightly by version.
Calculation mode can be confusing because it is a workbook-level setting that may be influenced by other open workbooks. If Automatic is selected but results remain stale, select the formula cell and press F2, then Enter to prompt Excel to re-enter it. On Windows, F9 recalculates formulas; Ctrl+Alt+F9 forces a full recalculation. On Mac, use Formulas > Calculate Now if the keyboard shortcut differs on your keyboard or version.
Also check that the formula is not surrounded by an apostrophe or entered with a leading space that makes it text. A formula stored as text will remain visible rather than calculating, even if its spelling looks correct. Correct the cell format, remove the extra character, and re-enter the formula.
A quick troubleshooting order
When a TRUE/FALSE result still looks wrong, work through these checks in order. This separates formula mistakes from data problems and avoids changing a correct formula to compensate for bad source values.
- Confirm the formula begins with
=and that every parenthesis and quotation mark is paired. - Verify the cell references against the intended row and column, including any fixed references used when copying.
- Check whether the input values are numbers, logical values, or text; do not rely on appearance alone.
- Inspect text for spaces, different punctuation, or inconsistent spelling. Use EXACT only when case-sensitive matching is required.
- Look for errors in the inputs and determine whether they should be fixed or deliberately handled.
- Set calculation to Automatic and recalculate if the displayed result appears out of date.
- Check the result cell’s number format and make sure Show Formulas is not displaying formula text instead of results.
If the problem occurs in only one row, compare that row with a nearby row whose result is correct. Differences in data type, hidden characters, or references often become clear when you inspect the cells side by side. If every formula in the workbook is affected, focus first on calculation mode, cell formatting, and whether formulas are being stored as text.
Frequently Asked Questions
Why does Excel show FALSE when two cells look the same?
They may contain different underlying values, such as a number stored as text, an extra space, or a different character. Check the cell contents and types, then clean or convert the source data as needed. If capitalization must match exactly, use EXACT; normal Excel text comparisons ignore case.
How do I make a cell display TRUE or FALSE?
Enter a condition that evaluates to a logical value. For example, with values in A2 and B2, =A2=B2 displays TRUE when they match and FALSE otherwise. You do not need an IF function unless you want different output such as Yes and No.
Why is my formula showing instead of TRUE or FALSE?
The cell may be formatted as Text, the formula may have an apostrophe or extra character before the equals sign, or Show Formulas may be enabled. Set the cell to General and re-enter the formula. If formulas are displayed throughout the sheet, turn off Show Formulas from the Formulas tab.
Can Excel compare TRUE with the text “TRUE”?
Yes, but they are different types. A cell containing the logical value TRUE is not the same as a cell containing the text characters TRUE. Use the comparison that matches the data you have, and convert imported data if downstream calculations require logical values.
Why does TRUE or FALSE not update when I change another cell?
Check Formulas > Calculation Options and select Automatic. If calculation is already automatic, confirm that the changed cell is actually referenced by the formula and that the formula has not been stored as text. Recalculating will not correct an incorrect reference.
Related
- Excel Custom Number Format for Millions
- Excel Custom Number Format: Show Numbers in Thousands
- Excel Shortcut to Select the Rest of a Column Down
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Can’t Hyperlink in Excel? Create and Fix LinksYes, you can add clickable hyperlinks in Excel to websites, files, email addresses, and places in a workbook.…
- Excel CONCAT to Remove a File Name SuffixCONCAT in Excel joins text; it does not remove a file-name suffix by itself. To remove the last…
- Excel Cannot Open the File: How to Fix a Corrupt XLSXYes—Excel may be unable to open an XLSX when its workbook file is damaged, incomplete, or not really…
- Excel File Format and Extension Error: Causes and FixesThe Excel message “The file format and extension of [filename] don’t match” means Excel cannot confirm that the…
- Excel File Not Responding: Fix Freezes and CrashesIf an Excel file says Not Responding, first wait a minute or two without clicking repeatedly; a large…
- Excel Not Removing Duplicates? Fix Common CausesIf Excel is not removing duplicates, first check that you selected the full data range and the correct…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.