#1
|
|||
|
|||
won't show blank cell
i have entered a formula =H14+G14-I14 in cell J14
I have set the sheet to show 0 as a blank, the cells are formatted to time but if the result in j14 is 0:00 it shows in the cell and is not blank? the rest of the cells in the sheet will be blank on 0 can someone help? |
#2
|
|||
|
|||
You can try to use a custom format in the format cells option. Under custom type 0;-0;;@
This should make it blank when it equals 0. Also there is of course an if formula that will make it 0 if the sum = 0 |
#3
|
|||
|
|||
Hi,
When will you apply formula on 'J' cell then it will show the actual result of calculation done by applied formula, It does not matter that what you have already set in 'J' cell. Can you please share sample of your data ? So that i could explain it more. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Laptop screen blank but images show on projector | riverpilot | PowerPoint | 0 | 11-10-2012 09:16 AM |
show a cell | s7y | Excel Programming | 26 | 05-26-2012 08:00 PM |
Can I create a formula that will show result in the same cell and let me copy it down | CranstC | Excel | 1 | 02-11-2012 01:29 AM |
Show the first item of a drop-down list instead of a blank | Pragabhava | Excel | 1 | 12-29-2011 11:48 PM |
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank? | Learner7 | Excel | 1 | 04-25-2011 04:39 AM |