On Jul 9, 7:21*pm, Redsphynx
wrote:
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

could use NA() instead of "".... =IF(E2="",NA(),F1+E2)
this will ignore that point in the plot