View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Redsphynx Redsphynx is offline
external usenet poster
 
Posts: 22
Default Creating a blank cell for a chart to ignore

Hi,
I need to use this formula for my charts, =IF(E2="","",F1+E2)
but what I need it to do is to ignore these blank cells until there is a
false response.

At the moment my chart is plotting these as $0.00 right along the bottom of
the chart, and what I need is for it not to display until an amount is in the
cell.

Thanks,
Craig