Ask Your Question

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

asked 2016-07-29 01:00:43 +0100

Chris Y. gravatar image

updated 2020-08-20 13:53:34 +0100

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-20 13:54:05.040620

1 Answer

Sort by » oldest newest most voted

answered 2016-07-29 03:09:12 +0100

LKeithJordan gravatar image

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.

edit flag offensive delete link more

Question Tools



Asked: 2016-07-29 01:00:43 +0100

Seen: 732 times

Last updated: Jul 29 '16