No void value skipped by graphic chart

  • Thread starter Thread starter news.tin.it
  • Start date Start date
N

news.tin.it

I use Excel 2000.
If the cell contet is "" and it is e result of a formula like
IF(True;"";1) the "" value is used like e zero in all type of graphics.
Why the graphic doesn't skip "" value????
If the cell is really void then graphic ship the value. Is there a
return value for IF function that works like a void?

Tank you all
Andrea
 
Hi,

Try using NA() instead of "".

Cheers
Andy

news.tin.it said:
I use Excel 2000.
If the cell contet is "" and it is e result of a formula like
IF(True;"";1) the "" value is used like e zero in all type of graphics.
Why the graphic doesn't skip "" value????
If the cell is really void then graphic ship the value. Is there a
return value for IF function that works like a void?

Tank you all
Andrea
Click to expand...
 
A little explanation: "" is not a void, a null, or a blank, no matter
how it looks to us mere mortals. It is a very short piece of text, and
Excel evaluates the value of text as zero.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Further information...

Apparently the Italian excel equivalent of NA() is NON.DISP
 
Back
Top