No void value skipped by graphic chart

[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

 

[Andy Pope]

Hi,

Try using NA() instead of "".

Cheers
Andy

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

 

[Jon Peltier]

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/
_______

 

[Andy Pope]

Further information...

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