I am using an IF function that states as the following
[in Cell B1]
=IF (A1="ABC","","ELSE")

When this IF statement is TRUE, I want B1 to be a blank cell, hence the
two double quote sign without a space in between.
However, I found out that

*"COUNTBLANK (B1)" will result in 1, meaning that with COUNTBLANK
function picks B1 as a "BLANK" Cell.

*"ISBLANK (B1)" will result in FALSE, meaning that with ISBLANK
function considers B1 as a "Filled" Cell.

WHAT I WANT TO KNOW IS THE WAY TO SET B1 CELL IN A IF FUNCTION THAT IS
COMPLETELY AND PURELY BLANK SO THAT THE \"ISBLANK (B1)\" FUNCTION WILL
RESULT IN TRUE.

Does anyone know the way to do this?

The notion of Pure Blank is important when creating a pivot table,
also. By programatically setting the blank cell with "" (2 double
quotes), Pivot Table generation logic counts these as data, not blanks
thus the data count becomes inaccurate.

Thank you very much for your help in advance,


--
yokato95
------------------------------------------------------------------------
yokato95's Profile: http://www.excelforum.com/member.php...o&userid=26405
View this thread: http://www.excelforum.com/showthread...hreadid=396804