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:

"garyww" ha scritto nel messaggio
...

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

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

now look at preview you would not see errors and these would also not
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
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:




--
garyww


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=571744