|
| 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
March 24th, 2004, 11:22 PM
|
|||
|
|||
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
March 24th, 2004, 11:33 PM
|
|||
|
|||
|
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
March 24th, 2004, 11:46 PM
|
|||
|
|||
|
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
March 24th, 2004, 11:47 PM
|
|||
|
|||
|
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
March 25th, 2004, 12:34 AM
|
|||
|
|||
|
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
March 25th, 2004, 12:45 AM
|
|||
|
|||
|
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 | |
|
|
Linear Mode
