Excel Yes/No Formula Not Working? Common Causes and Fixes

Errors & fixes · Updated November 19, 2026

If an Excel yes/no formula is not working, check that the formula points to the right cell, uses the correct comparison, and is being recalculated. For a basic result, with a score in A2, enter =IF(A2>=50,"Yes","No"): if A2 contains 42, Excel returns No; if it contains 72, Excel returns Yes.

How a yes/no formula works

A yes/no formula is usually an IF function: Excel checks a condition and returns one value when it is true and another when it is false. The general pattern is =IF(condition,"Yes","No"). The condition can test a number, compare text, check whether a cell is empty, or evaluate another expression. The words Yes and No must be enclosed in straight double quotation marks because they are text values.

Before diagnosing a problem, decide what the formula is supposed to test. For example, “Yes if the amount is positive” is different from “Yes if the cell contains the word Paid.” A formula can be syntactically valid and still give an unexpected answer if its condition does not match the rule you intended.

With a payment status in A2, where A2 contains Paid, the exact-text test =IF(A2="Paid","Yes","No") returns Yes. If A2 contains Unpaid, it returns No. With a number in B2, where B2 contains 0, =IF(B2>0,"Yes","No") returns No. The comparison operator matters: >0 excludes zero, while >=0 includes it.

Check the cell reference and condition

A common cause is a reference to the wrong cell or row. If the values are in column B but the formula checks column A, the output may look plausible while being wrong. Click the formula cell and inspect the colored reference highlighted in the worksheet. Confirm that it points to the input you mean to test, and check that the row number is correct.

When copying a formula down a column, Excel normally adjusts relative references. A formula that refers to A2 becomes a reference to A3 in the next row, which is usually what you want. But copying across columns or using a fixed threshold can shift a reference unexpectedly. If the cutoff is stored in D1 and should stay there as the formula is copied, use an absolute reference. With each row’s score in A2 and the fixed threshold in D1, =IF(A2>=$D$1,"Yes","No") returns Yes for a score at least as large as the value in D1. If A2 is 60 and D1 is 50, the result is Yes.

Also check the comparison itself. > and >= are not interchangeable, and = is not the same as <> (not equal). If a boundary value is being classified incorrectly, test the condition with a value exactly on that boundary. For example, a score of 50 returns Yes for a condition of at least 50, but No for a condition of greater than 50.

Look for text and number mismatches

Excel distinguishes between numbers and text that looks like a number. A cell displaying 50 may contain the number 50 or the text string “50”; imported data, leading apostrophes, and some copy-and-paste operations can create text values. A comparison or calculation may then behave differently than expected. Select the input cell and check the formula bar, its number format, and whether Excel shows a warning indicator. Changing the number format alone does not always convert text into a number.

Text comparisons can also fail because the cell contains extra spaces or a slightly different word, such as “Paid ” with a trailing space. With the status in A2 and an ordinary extra space around the word Paid, =IF(TRIM(A2)="Paid","Yes","No") returns Yes after removing leading and trailing spaces. TRIM does not remove every unusual character that can arrive in copied data, so if the text still does not match, inspect the source or clean the imported values.

Check spelling, punctuation, and the actual content of the cell rather than relying only on what appears in a narrow column. “Yes” as a text result is not the same thing as the Boolean value TRUE. If another formula or system expects TRUE/FALSE, returning the words Yes and No may cause a separate mismatch even though the IF formula itself works.

Understand blank cells and missing data

A blank input often gets treated as zero in a numeric comparison. As a result, a formula that tests whether a value is below a threshold might return Yes for an empty cell, even though you wanted no answer until someone enters data. Decide explicitly how blanks should be handled: should they display nothing, show No, or prompt for follow-up?

With the value in A2, this formula leaves the result blank when A2 is empty and otherwise checks whether it is at least 50: =IF(A2="","",IF(A2>=50,"Yes","No")). If A2 is empty, the result is an empty string; if A2 is 50, the result is Yes. Note that a formula returning an empty string is not the same as a truly empty cell. Other formulas and filters may still treat that cell as containing a formula.

For a data-entry checklist, returning an explicit status may be clearer than displaying a blank. The important point is to build the blank-cell rule into the logic rather than assuming Excel will infer what an empty input means.

Check formula syntax and regional settings

If Excel displays an error such as “There’s a problem with this formula” as soon as you press Enter, inspect its syntax. Confirm that the formula starts with an equals sign, that each opening parenthesis has a matching closing parenthesis, and that text results use straight quotation marks. Curly quotation marks copied from a document can be rejected or interpreted differently.

In Microsoft 365 for Windows, the examples here use commas between function arguments. Some regional configurations use a different list separator, commonly a semicolon; if Excel rejects a correctly structured formula, check the separator used by formulas already working in that installation. Do not replace commas at random: the separator depends on the computer’s regional settings. Excel for Mac and Excel for the web can also reflect the locale and settings of the environment.

Be careful not to type an apostrophe before the equals sign. A leading apostrophe tells Excel to treat the following entry as text, so the formula may appear in the cell instead of calculating. Likewise, if a cell was formatted as Text before the formula was entered, Excel can display the formula characters rather than a result. Change the cell format to General, then re-enter the formula; changing the format alone may not convert an already stored text entry.

Make sure Excel is calculating

Sometimes the formula is correct but its displayed result has not updated. In Excel for Microsoft 365 on Windows, open Formulas > Calculation Options and select Automatic. If calculation is set to Manual, changing an input may leave dependent formulas showing old results until recalculation. This setting can affect the workbook, so check it when several formulas appear stale at once.

To recalculate the active workbook on Windows, press F9. If a laptop uses function keys for hardware controls, you may need Fn+F9. On Mac, use Formulas > Calculate Now when available, since keyboard behavior varies by keyboard and Excel configuration. If the formula still shows an old value, confirm that calculation is not set to Manual and that the formula references the cell you changed.

Another display issue is Show Formulas, which shows formulas in cells instead of their calculated results. On Windows, Ctrl+` (the grave-accent key, often beside 1) toggles this view. On Mac, the shortcut can differ by keyboard layout, so use the Show Formulas command on the Formulas tab if needed. A wide column or a leading apostrophe can also make formula text visible, but those are different causes.

Use a practical troubleshooting sequence

Work through the problem in order so you can isolate the cause instead of rewriting a formula that is already correct. Save a copy first if the workbook contains important data, especially before making broad changes or replacing formulas in many cells.

  1. Click the result cell and check whether the formula begins with an equals sign or is stored as text.
  2. Read the condition and confirm the referenced input cell, comparison operator, and intended cutoff.
  3. Inspect the source cell for spaces, unexpected text, a blank value, or a number stored as text.
  4. Check quotation marks, parentheses, and the argument separator used by your regional settings.
  5. Set calculation to Automatic if results are not updating, then recalculate and check for Show Formulas mode.
  6. Test the condition with a simple known input, such as a value below, at, and above the cutoff.

If Excel shows #NAME? or another error rather than Yes or No, read the error as a clue. A misspelled function name or unrecognized text can cause #NAME?; a circular reference warning can mean the formula depends on its own result, directly or indirectly. A normal IF formula should not need to refer to its result cell. Correct the reference or function syntax rather than hiding the error with formatting.

Choose the right output for your task

The words Yes and No are useful for people reading a report, but they are not always the best values for later calculations. If a downstream formula needs a logical test, TRUE and FALSE may be more suitable; if it needs a numeric flag, 1 and 0 can be easier to sum. Choose the output based on how the result will be used, and make sure any other formulas expect the same type of value.

For a simple yes/no status, the IF function is usually clearest. If the rule has several categories, a long chain of nested IF functions can be difficult to maintain. Consider keeping the rules in a small lookup table or using a more suitable function when the conditions grow. Whatever approach you use, document boundary rules—such as whether exactly 50 counts as Yes—and test representative inputs before filling the formula through a large dataset.

Frequently Asked Questions

Why does my Excel formula show the formula instead of Yes or No?
Check whether the cell is formatted as Text, has a leading apostrophe, or Show Formulas is on. Set the format to General and re-enter the formula, and turn off Show Formulas if the worksheet is displaying formulas everywhere.

Why does a blank cell return Yes or No?
A blank can behave like zero in a numeric comparison. Add a blank check before the main condition if an empty input should produce an empty result or a separate status.

Why does my formula return No when the cell says Paid?
The cell may contain extra spaces, different wording, or hidden characters, or the formula may reference another cell. Check the source content and reference; TRIM can handle ordinary leading and trailing spaces.

Why does Excel say there is a problem with this formula?
Check the equals sign, parentheses, straight quotation marks, and argument separators. Some regional settings use semicolons rather than commas, so compare with a working formula in the same Excel installation.

Why does the answer not change when I edit the input?
Calculation may be set to Manual, or the formula may point to a different cell. Select Formulas > Calculation Options > Automatic on Windows, then recalculate and verify the reference.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.