enter a null or "blank" value in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(A1>10,"","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?
 
...
...
. . . Does anyone know how to have an actual NULL value
entered in the cell vs. a "" or blank in a function?
Click to expand...

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