wanting to NOT plot #Div/0 on chart

B

Brandy

Good afternoon,

I have serveral charts that plot #div/0 as zeros. My current function is
simple (=sum(D3+G3)/C3), which returns the #div/0 in the reports containing
the chart info. Is there a formula I could use (NA? possibly) that would
take care of this problem?

Thank you!
 
D

David Biddulph

Asking 3 times in no more likely (in fact probably less likely) to give you
an answer than asking once.
 

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

Not wanting to plot #div/0 1
not wanting #div/0 to chart as zero 2
Don't want to plot blank cells on my chart 4
Do not want chart to graph cells with formulas that are "blank" 1
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1
"#DIV/0!" ----->>> I'd like the best way to check for Error.Type into my formula..... 0
OLD PROBLEM without SOLUTION , part || 1
Relative vs Absolute referencing of Workbooks 4

Top