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

Surpressing plot of blank cells 3
Blank instead of "" 5
How do I not plot zero values that result from a formula in Excel? 1
Auto set data ranges 2
Plotting "blank" cells as zero 3
Hiding zeros in dynamic charts 3
Making a Blank Cell 1
I need a gap when the result of a formula is blank or zero 3

Top