Display "0" if error

Formula > Wrap in IFERROR (zero)

This tool wraps a formula in a cell into a =IFERROR() function with an alternative value of "0" (zero).

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

For example, if you have a formula VLOOKUP but no result is found, then the formula will display #N/A. You can use this utility to tell LO Calc what to display when a formula produces an error, for example display null if no result is found.

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

Screenshot

Before wrapping:

After wrapping:

Launch this tool

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

How much time will it save?

Using this tool, you are guaranteed to save time and effort. However, the actual time savings depends on how often you use LibreOffice Calc, the amount of data you work with, and how often you use the tool.

Download

If you don't already have YLC Utilities, you can download the free version "YouLibreCalc.oxt" or the full-featured version "YLC_Utilities.oxt" .