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 wrote:
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, Microsoft MVP - Excel
http://www.andypope.info

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 wrote:

Hi,

Try using NA() instead of "".

Cheers
Andy

news.tin.it wrote:

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

Further information...

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

Andy Pope wrote:
Hi,

Try using NA() instead of "".

Cheers
Andy

news.tin.it wrote:

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, Microsoft MVP - Excel
http://www.andypope.info