How do I clear a cell

[soconfused]

How do I clear a cell instead of blanking it.

Here is my current formula:
=IF(E5="","",SUM(B4:B5)/SUM(D45))

I am using this for a chart and I don't want to blank the cell becauase it
causes the chart to look horrible. I just want the data to stop on the chart.

In other words my chart goes from say 74 down to zero and I just want the
data point to stop at 74.

 

[Bob Phillips]

Do you mean that you want to stop plotting any points from there, or that
you want the datapoint to pick up the previous value?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[soconfused]

I want to stop plotting any points from there.

 

[Pete_UK]

Change your formula to this:

=IF(E5="",na(),SUM(B4:B5)/SUM(D45))

This will give you #N/A errors where column E is blank, and these
errors will not affect your graph. If you don't want to see #N/A in
the cells, you can apply conditional formatting to the cells to print
white on a white background (thus making them appear blank).

Hope this helps.

Pete

 

[Bob Phillips]

I think you need a dynamic range for the data.

Let me check, where are the formulae that you posted?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)