If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
enter a null or "blank" value in a cell
How do I get an Excel Function to place a NULL value in a
cell vs. a blank or space. Here an example: Cell A1 contains the number 11, when I enter the formula =IF (A110,"","text") it results in a blank value in the cell vs. NULL or nothing. This is a problem when I am charting the values because the chart interprets the value of a cell containing double quotes "" as a 0 and charts the 0, when what I want is for that cell not to chart at all, which would happen if the cell were completely blank (null). Does anyone know how to have an actual NULL value entered in the cell vs. a "" or blank in a function? |
#2
|
|||
|
|||
enter a null or
" wrote...
... . . . Does anyone know how to have an actual NULL value entered in the cell vs. a "" or blank in a function? No one knows because it can't be done. This is one of Excel's well-known and very frequently discussed shortcomings. If charting is your concern, use #N/A rather than "". -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
Thread Tools | |
Display Modes | |
|
|