no #VALUE! to printout

[garyww]

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: (e-mail address removed)

 

[Franz Verga]

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.

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.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[starguy]

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.