Excel: Empty cell in 2007
[Closed]
Report
RT

Sushant 
Sushant 
Related:
 Excel: Empty cell in 2007
 Excel if cell contains date then return value ✓  Forum  Office Software
 Excel if cell contains text then return value in another cell ✓  Forum  Excel
 Excel if cell contains text then copy to another sheet ✓  Forum  Excel
 Excel: If Date =, then enter a value ✓  Forum  Excel
 Excel blinking cell without vba ✓  Forum  Excel
4 replies
mubashir aziz
 Posts
 190
 Registration date
 Sunday April 12, 2009
 Status
 Member
 Last seen
 February 16, 2010
You just use NA() function and excel chart will treat it as empty cell ..... then you can hide it in printing by File > Page Setup > Sheet > Cell Error <Blank> ...
You can hide Error values by conditional formating by putting this formula =+ISNA(C5) suppose values are in C5 ......
So your formula is
=if((sum(a1:a5))=0,NA(),(sum(a1:a5)))
You can hide Error values by conditional formating by putting this formula =+ISNA(C5) suppose values are in C5 ......
So your formula is
=if((sum(a1:a5))=0,NA(),(sum(a1:a5)))
PicaPica
 Posts
 1
 Registration date
 Friday April 17, 2009
 Status
 Member
 Last seen
 April 17, 2009
Did you find an answer?
I have the same problem.
Inan IFfunction, I do not know which empty result would make an empty cell.
I have the same problem.
Inan IFfunction, I do not know which empty result would make an empty cell.
Brilliant ! I've been struggling with this since yesterday, awesome stuff.
(I used the #N/A method  it still seemed to count " " as Zero)
Ta  Nathan.
Found a better solution! Leave your formulas and let them return the zeros.
Then in your chart, add data labels, then format the labels to hide the zeros. Got to Edit Labels, Number options, and use a Custom format and enter 0;;; then click Add. You might have to change the 0 to 0.0 or 0% or whatever is appropriate for your data values.
The format string syntax is:
positive value format; negative value format; zero value format; text value format.