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?

" 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.