logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Monday March 2nd, 2026

Tip of the Day | Monday March 2nd, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Replace Formula Errors with a Custom Message...

Turn confusing formula errors into helpful messages or hide them completely.
Instead of displaying standard Excel error values like #N/A, #VALUE!, or #DIV/0!, this tool allows you to automatically replace them with your own text or leave them blank.
For example, if a formula like =A1*B1 returns #VALUE! because one of the cells contains text instead of a number, you can replace it with a user-friendly message like "Invalid input" or simply show a blank cell.
You can do this manually, but it is easier and faster with the help of this tool.
This tool:
  • Automatically wraps existing formulas with =IFERROR(your_formula, your_custom_message)
  • Works on multiple formulas at once, even if they are different
  • Avoids manual edits, making formula management easier
    Make your spreadsheets cleaner and easier to read by controlling what users see when formulas return errors.

    Screenshots

    Example screenshot: Hide or replace error values
    Hide or replace error values

    Starting this tool


    Formulas  ›  Replace Formula Errors with a Custom Message...

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.