View Single Post
  #4   Report Post  
Andy Pope
 
Posts: n/a
Default

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