| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link to an empty cell question.
Hello,
I have a cell with a link to another cell which will either be blank(empty) or contains a number. Currently, when the source cell is empty a 0 appears in the destination cell. If the source is empty Id like the link to return a null instead of 0. Is there a setting to do that without using =IF() in the link cell? I also would not like to use a space to clear the source cell. Any ideas are appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reposted question: If cell is empty show userform???????? | Excel Discussion (Misc queries) | |||
| Question: Is it possible to link a cell to a comment box window? | Excel Discussion (Misc queries) | |||
| Question: Is it possible to link a cell to a comment box window? | Excel Discussion (Misc queries) | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| empty cell question | Excel Worksheet Functions | |||
Threaded Mode
