Ask Your Question
0

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

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

Chris Y. 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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

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
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 366 times

Last updated: Jul 29 '16