How do I clear a cell


S

soconfused

How do I clear a cell instead of blanking it.

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

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.
 
Ad

Advertisements

B

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)
 
P

Pete_UK

Change your formula to this:

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

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
 
Ad

Advertisements

B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top