![]() |
|
#1
|
|||
|
|||
![]()
I have created a chart from 3 columns of data.
Two columns are complete, one column is built up gradually from data on another sheet. (Sheet 1) All data is plotted correctly but an empty cell is treated as 0 and not ignored as I would like. How can I get round this? This is the function I am using in the incomplete column. =IF(Sheet1!E2>0,Sheet1!E2,"") |
#2
|
||||
|
||||
![]()
Hi Colin,
Try this: =IF(Sheet1!E2>0,Sheet1!E2,NA()) because #N/A errors should be ignored. |
#3
|
|||
|
|||
![]()
Thanks Colin. Just what I wanted.
Colin |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Hwyn | Excel Programming | 2 | 11-14-2011 11:44 AM |
![]() |
rene.kamphuis@ciz.nl | Mail Merge | 21 | 04-15-2011 12:34 AM |
Shared Calendar Empty | worksmart | Outlook | 0 | 01-21-2011 06:32 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Populate an empty .PAB file | imported_contiw | Outlook | 2 | 08-17-2006 08:50 PM |