Display "blank" if error

Formula > Wrap in IFERROR (empty)

This tool wraps the formula in the cell into the function =IFERROR() with an alternative value of "" (empty).

Instead of an error like #N/A, #DIV/0!, or #VALUE!, you can have your own (more logical) error message displayed when a formula results in an error.

For example, if you have a formula VLOOKUP, but no result is found, then the formula will display the value #N/A. You can use this utility to report Excel that it should display when the formula results in an error, for example, display nothing (empty result) if no result is found.

This is much faster than typing =IFERROR() for each cell manually.

Screenshot

Before wrapping:

After wrapping:

Running this tool

Click YLC Utilities > Formula > Wrap in IFERROR (empty) :

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Wrap in IFERROR (empty) by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .