Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
empty links display
Dear Excel Experts-
I have many cells linked to other worksheets but when nothing has been entered in the source, the link displays as zero. Is there anyway to specify what is displayed when the source is empty? Can I tell it to n/a or just to print nothing? Thanks- Allison |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
empty links display
Try this:
=IF(Sheet2!B1<"",Sheet2!B1,"") This returns a blank cell. Enter anything else you might like displayed, in between the set of double quotes. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Allison" wrote in message ... Dear Excel Experts- I have many cells linked to other worksheets but when nothing has been entered in the source, the link displays as zero. Is there anyway to specify what is displayed when the source is empty? Can I tell it to n/a or just to print nothing? Thanks- Allison |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filters how do i keep the display list empty until filter applied | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
Display empty cells | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
Display a dialog box if cell is empty | Excel Discussion (Misc queries) |