no #VALUE! to printout

[garyww]

i got some cell with the #VALUE! displayed on the cell and can see o
the
worksheet. Then I preview also can see this #VALUE! or even I printe
out
i then can see this #VALUE!.
Now I don't want this #VALUE! printed out on the paper. How to d
that.
Or no #VALUE! show on the cell. However, #VALUE! contains a formul
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 valu
in the coming future. The fformula must remain.


thanks to let me know
gar
email: (e-mail address removed)

 

[Bondi]

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)

Hi,

I think the #VALUE comes when the formula is in error - Then it is
trying to ROUND("") and this results in the #VALUE. You could try to
put the ROUND() within the ISERROR()

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

I haven't tested the formual so i don't know if it works as it is here.

Regards,
Bondi