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
------------------------------------------------------------------------
garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818
View this thread: http://www.excelforum.com/showthread...hreadid=571678

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
------------------------------------------------------------------------
garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818
View this thread: http://www.excelforum.com/showthread...hreadid=571678

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