I'm looking for something along the lines of
B3 = IF(A3=N/A;B1+B2;A3+B1+B2)
I want to plot a sequence of numbers on a line chart but I do not want it to show values of 0. The only solution I could find was outputting N/A instead of zero or blank. Any entirely different solution that makes sure my line graph does not draw when output = blank/zero would also solve my problem.
Try:
A3: =IF(COUNTBLANK(A1:A2),NA(), A1-A2)
B3: =IF(COUNTBLANK(B1:B2),NA(), B1-B2)+IF(ISNA(A3),0,A3)
and copy B3 across
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you, the IF(ISNA) was exactly what I was looking for!
You're welcome. Thanks for the rep.
Note also the NA() which generates the #NA error which is not charted. And ISNA picks this up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks