Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another Quick Question
How do I keep my cells from showing "#Value" (in a blank cell w/ a formaula)
when I print a worksheet? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another Quick Question
It depends which sort of formula you're using, can you post it? -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=538168 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another Quick Question
I have it set up so that when I type a certain number (ie 101) in cell A1 it
will post a number or description in C1. This a quote sheet for customers, so I want to be able to see certain numbers, but then when I print, I would like certain cells blank. "daddylonglegs" wrote: It depends which sort of formula you're using, can you post it? -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=538168 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Another Quick Question
=if(iserror(formula),"",formula)
or if you want to see the error except for printing, use a dummy cell. Let's say it is cell Z1 =if(Z1="",formula,if(iserror(formula),"",formula)) then when you want to print, put a value in Z1. You can also use conditional formatting and check for an error value. then if it is an error, change the font color to match the background. However, some printers will recognize this lack of contrast and adjust the color so you can see the value. -- Regards, Tom Ogilvy "Heather" wrote: I have it set up so that when I type a certain number (ie 101) in cell A1 it will post a number or description in C1. This a quote sheet for customers, so I want to be able to see certain numbers, but then when I print, I would like certain cells blank. "daddylonglegs" wrote: It depends which sort of formula you're using, can you post it? -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=538168 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Question | Excel Discussion (Misc queries) | |||
Quick Question re For and Next | Excel Programming | |||
Quick question - quick answer about assigning shortcut keys | Excel Programming | |||
Very Quick Question | Excel Programming | |||
Quick question | Excel Programming |