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