How do I set a result of an "if" function to NULL; not 0 or ""?

M

mbrockhaus

I'm using an "if" statement and I want to set the TRUE condition results to
NULL rather than "0" or "". Is there a way to do this?
 
M

mbrockhaus

Did that. I need to concatentate the results and so, if something "failed"
the if check, I need the results to be NULL (or blank), without Excel
thinking something is really in the cell (like a space; even "" seems to not
be the same thing). I think I really need a WHEN function more than an IF.
 
M

mbrockhaus

I need to concatentate the results and so, if something "failed" the if
check, I need the results to be NULL (or blank), without Excel thinking
something is really in the cell (like a space; even "" seems to not be the
same thing). Probably need something like a WHEN more than an IF.
 
B

bj

You will need to have a macro to do this.
You cannot have a Blank in a cell as the result of an equation in that cell.
the macro which would be needed, depends on how the data is organized.

there are ways to get around the concatination of blank cells depending on
what you want to do.
 
Top