Blanks vs. Null values in Functions

  • 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. 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 only a problem when I am
charting the value 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 place an actual NULL
value entered in the cell vs. a "" or blank in a function?
 
How do I get an Excel Function to place a NULL value in a
cell vs. a blank or space. 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 only a problem when I am
charting the value 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 place an actual NULL
value entered in the cell vs. a "" or blank in a function?
Click to expand...

There have been several replies to the original posting of this question.
Please do not start a new thread on the same topic. Read the replies and, if
you still have a problem, reply to them in the same thread so we can follow
the history.
 
Back
Top