Home |
Search |
Today's Posts |
#1
|
|||
|
|||
no #VALUE! to printout
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: |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two worksheets, one printout? | Excel Discussion (Misc queries) | |||
Im trying to remove blank rows in an Excel spreadsheet Printout | Excel Worksheet Functions | |||
Convert excel printout into electronic file | Excel Discussion (Misc queries) | |||
my image in Excel inkjet printout has lines | Excel Discussion (Misc queries) | |||
suppressing a footer only on the first page of a printout | Excel Discussion (Misc queries) |