If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula with a blank cell
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. |
#2
|
|||
|
|||
Formula with a blank cell
Bennos
=IF("your formula"=0,"","your formula") For example: =IF(A1+B1=0,"",A1+B1) Regards Trevor "Bennos" wrote in message ... 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. |
#3
|
|||
|
|||
Formula with a blank cell
Beautiful work!! Thanks so much Trevor.
"Trevor Shuttleworth" wrote in message ... Bennos =IF("your formula"=0,"","your formula") For example: =IF(A1+B1=0,"",A1+B1) Regards Trevor "Bennos" wrote in message ... 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. |
#4
|
|||
|
|||
Formula with a blank cell
Hi
see your replieas in Excel.misc P.S.: please don't multipost -- Regards Frank Kabel Frankfurt, Germany Bennos wrote: 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. |
#5
|
|||
|
|||
Formula with a blank cell
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 "Trevor Shuttleworth" wrote in message ... Bennos =IF("your formula"=0,"","your formula") For example: =IF(A1+B1=0,"",A1+B1) Regards Trevor "Bennos" wrote in message ... 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. |
#6
|
|||
|
|||
Formula with a blank cell
One of the cells which I applied this formula to is showing "#VALUE!"
instead of a blank cell. "Bennos" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|