Linking to a data range containing blank cells

  • Thread starter James from Sage
  • Start date
J

James from Sage

I'm using MS Excel 2003.

I've got a chart from range of data gives the calculates accumulated total
from another table and would like the option to have the calculation result
in a blank cell that is not plotted as a zero.

I tried the following IF statement: =IF(Q6="","",Q6+P12) but "" is still
treated as a zero.

Any suggestions?

Thanks,

- James
 

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

Similar Threads

Using INDIRECT in named range for chart data series 1
Blank instead of "" 5
Surpressing plot of blank cells 4
How do I not plot zero values that result from a formula in Excel? 1
Auto set data ranges 2
scatter chart with gaps in series (XL 2007) 7
I need a gap when the result of a formula is blank or zero 3
Making a Blank Cell 2

Top