Formula Errors

How to Fix Excel IF Formula Returning FALSE or #NAME? Error

Maira Mehtab Sep 20, 2026 870 views

Question details

Users are experiencing IF formulas unexpectedly returning FALSE or a #NAME? error, particularly when writing custom formulas to convert decimal hours into an "hours and minutes" text format.

Product: Excel
Device & OS: not provided
Scenario: Evaluating conditions with the IF function or formatting decimal hour values into a descriptive text string.
Observed behavior: The formula displays a FALSE logical value, throws a #NAME? error, or fails to correctly convert the decimal values into hours and minutes.

Before you start

Double-check your formula syntax to ensure all parentheses are properly closed and double quotation marks are correctly placed around any text strings.

Solution 1Recommended

Resolve Formula Syntax Errors (#NAME? and FALSE)

Correct missing arguments and quotation marks to fix the FALSE output and #NAME? error in your IF formula.

The #NAME? error typically appears when text values are not wrapped in quotes or a function is misspelled. A FALSE result appears when the 'value_if_false' argument is omitted from an IF function.

Fix the FALSE result

Ensure your IF formula has a defined 'value_if_false' argument. For example, change =IF(A1>10, "Yes") to =IF(A1>10, "Yes", "No") or use "" to return a blank.

Verify function spelling

Check that all function names (such as IF, SUBSTITUTE, TEXT) are spelled correctly in the formula bar to prevent #NAME? errors.

Add missing quotation marks

Ensure any text strings used within the formula are wrapped in double quotes. For instance, text like " hrs " and " mins " must have quotes.

Why FALSE appears: Excel defaults to returning the logical value FALSE if the evaluated condition is not met and the third argument in the IF formula is left blank.

Solution 2

Convert Decimal Hours to Text using SUBSTITUTE and TEXT

Use a combination of Excel functions to convert a decimal hour value into a formatted text string reading hours and minutes.

Solution 3

Apply Custom Number Formatting or Math Functions

Format the cell directly to display decimal hours accurately without utilizing complex nested text formulas.

WPS Spreadsheet Solution

Fix Formula Errors Seamlessly with WPS Spreadsheet

WPS Office Spreadsheet provides full compatibility with standard Excel formulas, including IF, SUBSTITUTE, and TEXT. Its intuitive formula auditing tools make it easy to spot missing quotation marks or incomplete arguments that cause #NAME? and FALSE errors.

1. Open your spreadsheet: Launch WPS Office and open the file containing the formula errors.
2. Locate the error: Select the cell displaying the FALSE or #NAME? error.
3. Use Error Checking: Navigate to the 'Formulas' tab and select 'Error Checking' to automatically diagnose missing arguments or typos.
4. Update the formula: Correct your formula syntax in the formula bar, ensuring all text strings are enclosed in quotes, and press Enter.

Fully compatible with Microsoft Excel formulas and standard file formats (.xlsx).Built-in Error Checking helps quickly identify syntax issues causing #NAME? errors.Free and lightweight, ensuring smooth performance even with heavy data calculations.Intuitive interface makes it simple to apply custom number formatting.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my IF formula return FALSE instead of a blank cell?

If you omit the third argument (value_if_false) in an IF formula, Excel defaults to returning the logical value FALSE when the condition isn't met. To return a blank cell instead, add empty quotation marks ("") as the third argument.

What causes a #NAME? error in Excel formulas?

The #NAME? error occurs when Excel doesn't recognize text in a formula. This usually happens if you misspell a function name, forget to put double quotation marks around a text string, or reference a named range that hasn't been defined.

How do I convert a decimal like 2.5 into 2 hrs 30 mins?

You can divide the decimal value by 24 (e.g., =A1/24) and apply a custom number format: [h] "hrs "mm "mins". Alternatively, use the INT and MOD functions to calculate the hours and minutes separately.

Do WPS Spreadsheets support the same formulas as Excel?

Yes, WPS Spreadsheets supports the vast majority of standard Excel formulas, including logical functions like IF and text functions like SUBSTITUTE and TEXT, making formula migration and calculation completely seamless.

Excel & Data Problems