enter a null or "blank" value in a cell

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?
 
H

Harlan Grove

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Function -- Return Null Value Help 2
Null Value Entered in a Cell by a Function 16
Blanks vs. Null values in Functions 1
If function across sheets prints value of cell 4
How does a function provide a blank cell as a result 2
Evaluate Multiple Cells for any Value 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
How do I put a blank value in a cell not using "" in a formula 2

Top