Data for Chart with Blank Formula Cells

[sparrowsm]

I am trying to chart a worksheet that contains many formulas. When th
result of the formula is zero, the cell is instructed to leave the cel
blank (which is important to the information being tracked). However
when I chart the data, it charts a ZERO for the cell.

I tried the interpolate feature, but because the cell has a formula i
it, it is not being read as "blank", even though the value is blank.

Help! If week one is 2, week three is "blank" (remember, cell actuall
has a formula that is returning the blank), and week four is 6, I do
get my chart to interpolate from week 2 to week 4?

Thanks for the help.

Su

 

[Frank Kabel]

Hi Sue
in your formula try returning NA() instead of ""
e.g.
IF(condition,yourformula,NA())

Frank

 

[sparrowsm]

Dear Frank,

It worked!

Thanks so much,

Su