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: