In Calc, how can I hide #VALUE! in a cell when printed?

I can set a document to hide zero values, but if I have a formula that’s missing a value, that cell always prints #VALUE! But can there be a way to not show that warning in print?

Look for “Information functions” and “ERROR.TYPE function” in LO Calc Help. There are a number of functions that will answer your needs, including IFERROR, ISERR, and ERROR.TYPE. Since you have specified #VALUE! as the error, let’s go there first.

Before we do, let me make one point. All of these approaches will mask the error on screen as well as in print. I prefer this result, however, because a worksheet full of errors that disappear when data is added can also mask an unrelated error that won’t disappear. In each of the examples shown below, the error is replaced with a zero. You can, of course, replace the zero value with whatever you choose.

For the #VALUE! error specifically, I would use a combination of nested functions:

IF(ISERROR([Your Formula]);IF(ERROR.TYPE([Your Formula])=3;0);[Your Formula])

Here is another approach that essentially tests for a Value:

IF(ISNUMBER([Your Formula]);[Your Formula];0)

Here is another, broader, approach that tests for any error:

IFERROR([Your Formula];0)

As you can see, there are many ways to approach the solution to your problem. I strongly recommend a little research in the Help documentation to determine the approach that works best for you.

Please click the check mark next to the response you believe best answers your question.