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.

"mbrockhaus" wrote:

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.

"bj" wrote:

What do you mean by "NULL"?
and why don't you want ""?

"mbrockhaus" wrote:

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?