CODEWITHSUNDEEP
excel
Jimmy
Jimmy

Reputation: 12487

Stop excel plotting blank cells

I currently have this code:

=IFERROR(IF(EDATE(A2,1)>TODAY(),"",EDATE(A2,1)),"")

However even though in some cases the cell is blank, it is still plotted on my graph. Apparently this is a know issue and I should use #N/A or NA() but neither or my implementations work:

=IFERROR(IF(EDATE(A2,1)>TODAY(),#N/A,EDATE(A2,1)),#N/A)

or 

=IFERROR(IF(EDATE(A2,1)>TODAY(),NA(),EDATE(A2,1)),NA())

They both still split out N/A text when I drag the formular down. Can anyone show me how this should be implemented please?

James

Upvotes: 0

Views: 53

Answers (1)

helena4
helena4

Reputation: 282

I'm not quite convinced what your end result should be but

you might want to put the #N/As in ""

or

to use =ISNA(cell address)

Give me a full circle example from what you have to what you want to get, so we can integrate it for you.

Upvotes: 1

Related Questions