Formula with a blank cell

  • Thread starter Thread starter Bennos
  • Start date Start date
B

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.
 
Bennos

=IF("your formula"=0,"","your formula")

For example:

=IF(A1+B1=0,"",A1+B1)

Regards

Trevor
 
Beautiful work!! Thanks so much Trevor.



Trevor Shuttleworth said:
Bennos

=IF("your formula"=0,"","your formula")

For example:

=IF(A1+B1=0,"",A1+B1)

Regards

Trevor
Click to expand...
 
Trevor,

Can I email you an example spreadsheet as I can't figure out a part of the
formula in whole. It's probably really simple.

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