Thread: Is it possible to plot discontiguous cells?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jean Ruch
 
Posts: n/a
Default Is it possible to plot discontiguous cells?

"Jean Ruch" schrieb im Newsbeitrag

= IF(A1 = "-", "=NA()", A1)

Hi Pete,


Sorry:
I guess it rather should look like

= IF(A1 = "-", #NA, A1)

In German Excel : =WENN (A1="-";#NV;A1)

regards

Jean

Reply With QuoteReply With Quote