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
|
|||
|
|||
Blanks vs. Null values in Functions
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 (A110,"","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? |
#2
|
|||
|
|||
Blanks vs. Null values in Functions
wrote in message
... 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 (A110,"","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? 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. |
Thread Tools | |
Display Modes | |
|
|