Can I formulaically set a cell to blank (non-Text, no value)?

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

I want to write a formula that performs a division
function between 2 other cells. If the cell that will be
divided is blank or 0, I want the cell with the result to
be Blank, that is to say, non-Text, no value, does not
equate to "" or 0. Is this possible in Excel XP?

I am only successful at tricking a cell to LOOK blank, but
when other formulas evaluate that cell, they see it as
either empty text or 0.

I am open to suggestions involving writing some VB script
as well. Can I call a macro from a formula (i.e. set the
value_if_true of an If statement to call a stored
procedure)?

If this is just not possible, at least I'll know to stop
trying to find an answer. Thanks.
 
Troy said:
I want to write a formula that performs a division
function between 2 other cells. If the cell that will be
divided is blank or 0, I want the cell with the result to
be Blank, that is to say, non-Text, no value, does not
equate to "" or 0. Is this possible in Excel XP?

I am only successful at tricking a cell to LOOK blank, but
when other formulas evaluate that cell, they see it as
either empty text or 0.

I am open to suggestions involving writing some VB script
as well. Can I call a macro from a formula (i.e. set the
value_if_true of an If statement to call a stored
procedure)?

If this is just not possible, at least I'll know to stop
trying to find an answer. Thanks.
Click to expand...

Not possible.
 
You cannot do this with a formula, but you could try a workaround by evaluating the cells in
question and checking that the length of the cell contents is 0, eg

=LEN(A1)=0

Failing that, what is the need for the blank cell, as maybe we can give you a workaround for
whatever formula you are using.
 
Back
Top