Formula Help - Blank cell unless!

[Bennos]

Hi all, thanks in advance!

Is there a way to have a cell with a formula display as a blank cell unless
there is a value? Eg, if the formula's value is 0 - the cell is blank. If
the formula's value is 2 the cell displays 2.

I hope that this is not too confussing.

 

[CLR]

=IF((yourformula)=0,"",(yourformula))

Vaya con Dios,
Chuck, CABGx3

 

[Frank Kabel]

Hi
try something like
=IF(your_formula = 0,"",your_formula)

 

[Bennos]

thanks so much! i've only been using very simple formulas in excel and find
it is an absolutely amazing spreadsheet program!!

 

[Bennos]

One of the cells which I applied this formula to is showing "#VALUE!"
instead of a blank cell.

 

[Bennos]

One of the cells which I applied this formula to is showing "#VALUE!"
instead of a blank cell.

 

[CLR]

Are you sure the formula is correct "before" applying the IF
warparound?........could be you're trying to add a cell with a number in it
together with a cell that has what looks like a number but is actually
text...............if you still have trouble, reply back with the offending
formula and maybe one of us can see if it contains an error.........

Vaya con Dios,
Chuck, CABGx3

 

[CLR]

Another way out of this situation instead of just making the cell blank with
your formula by using the "", is to go ahead and let it calculate to zero,
then apply Conditional Formatting to the cell and if the cell value is zero,
then turn the font white, (or whatever color your background is) and then
the cell will appear blank, but still be "multiply-able" in other formulas.

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

If you do not want to see Zero values, the easiest is to go to Tools->Options->View and then remove the check box for "Zero Values

 

[David McRitchie]

You asked this twice within your thread. So don't know which
subthread to answer.

It would be best to find out WHY you have an error, but if
suppression is all you want.

=IF(your_formula = 0,"",your_formula)
change to:
=IF(ISERROR(your_formula),"",IF(your_formula = 0,"",your_formula) )

A cell with a value "" is not an empty (or blank) cell, nor can any cell with
a formula be empty. An Empty cell is by definition one that has
nothing in it. A cell with a formula will never test
TRUE in Excel with ISBLANK, nor will it test True in VBA with ISEMPTY .