Is there a way to hide a function error indicator in a print view?

Question

Level 1

15 points

Is there a way to hide a function error indicator in a print view?

I've got a numbers report with a function error and I was wondering if there's a way to hide the exclamation point when printing it out? Not trying to hide something, just to avoid displaying an error when its unimportant.

Thanks!

iMac, Mac OS X (10.6.7)

Posted on Apr 3, 2012 3:07 PM

Reply

Answer 1

Best reply

Jerrold Green1

Level 7

30,210 points

Apr 3, 2012 4:27 PM in response to TimB21

Tim,

You might try including the IFERROR function in your expression. This will suppress the error message.

Jerry

Reply

Answer 2

TimB21 Author

Level 1

15 points

Apr 3, 2012 5:30 PM in response to Jerrold Green1

Perfection.

Thanks!

-=Tim=-

Reply

Answer 3

Barry

Level 9

59,861 points

Apr 3, 2012 6:26 PM in response to Jerrold Green1

(redundant) 😉

Barry

Reply