no #VALUE! to printout

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

garyww - 15 Aug 2006 08:38 GMT

i got some cell with the #VALUE! displayed on the cell and can see on
the
worksheet. Then I preview also can see this #VALUE! or even I printed
out
i then can see this #VALUE!.
Now I don't want this #VALUE! printed out on the paper. How to do
that.
Or no #VALUE! show on the cell. However, #VALUE! contains a formula
such as

=ROUND(IF(ISERROR((AM6/(AG6+AJ6+AM6)*AD6)*A6*1.05/840/AL6),
"",((AM6/(AG6+AJ6+AM6)*AD6)*A6*1.05/840/AL6)),3)

but those cell included in the forumla may perhaps will enter a value
in the coming future. The fformula must remain.

thanks to let me know
gar
email: garywwww3@hotmail.com

Signature

garyww

Reply to this Message

Franz Verga - 15 Aug 2006 14:34 GMT

> i got some cell with the #VALUE! displayed on the cell and can see on
> the
[quoted text clipped - 11 lines]
> but those cell included in the forumla may perhaps will enter a value
> in the coming future. The fformula must remain.

Hi Gary,

you can use an IF function to "incapsulate" the error value:

=IF(ISERROR(your_formula),"",your_formula)

In this way when a formula gives a #VALUE! error the cell will show "", a
null string, i.e. the cell will be blank.

Signature

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Reply to this Message

starguy - 15 Aug 2006 16:19 GMT

go to menu File > Page Setup click on Sheet tab, change the option "Cel
errors as" <blank>

now look at preview you would not see errors and these would also no
be printed even errors are present on your sheet.

hope this will serve your purpose.
garyww Wrote:

> i got some cell with the #VALUE! displayed on the cell and can see on
> the
[quoted text clipped - 18 lines]
> --
> garyw

Reply to this Message