Setting A blank as a result of an IF statement

M

mudshark

I want to create a chart with a trendline which takes the results of a
If statment as data input. Column F is date (used as the X AXIS) an
column G then contains values on certain days but not all days.
Like this =IF(ISBLANK(G4),G4,SUBTOTAL(9,G$2:G4))
SO I get a running total.
Where the cell in column G is blank the result is 0

I also tried using a zero-length string ie
=IF(ISBLANK(G4),"",SUBTOTAL(9,G$2:G4))
- This shows a blank in the result cell but the chart still plots it a
a '0'
I tried changing the plot options for chart to skip blanks but i
doesn't work.
Is this a bug
Is there any way arounf it
 
F

Frank Kabel

Hi
try
=IF(ISBLANK(G4),NA(),SUBTOTAL(9,G$2:G4))

and use conditional format to hide the #NA error codes
 
M

mudshark

Thanks Frank

The Chart works fine even if I leave the #NA error codes in th
spreadsheet.

Easy when you know how

Thanks again
:
 
Top