Null Value

[briank]

I am charting data that is based upon an "=if" conditional
statement. However, when the condition is not met I want
a null value [i.e. if(A1=4,4,null)] Since this doesn't
appear to work I am forced to use a space command [i.e. if
(A1=4,4,"")]. The problem is that Excel reads this "" as
a zero and graphs it accordingly.
What function can I use to avoid this?
Thanx.

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting with an
email copy to briank.
Please use the newsgroup for further discussion.]

Yes, you are right. XL doesn't have a function for 'this cell should
be empty.' The closest workaround is to use the NA() function as in
=IF(A1=4,4,NA())
--
Trouble finding replies to your posts? Use a newsreader. See the
tutorial 'Outlook Express and Newsgroups' on my web site

Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions