Not wanting to plot #div/0

B

Brandy

Good afternoon,

I have several reports, updated monthly, that until that month has passed,
contain formulas that return results of #div/0. These reports are all
charted and I would not to have the #div/0 not be on the chart as a zero
value.

My current formula is simple: =sum(d3+g3)/c3

Is there a formula I could use to have this value return as #N/A?

Thank you for your time and help!
 

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 #div/0 to chart as zero 2
wanting to NOT plot #Div/0 on chart 1
Supress DIV/0 2
Div / 0 6
DELETE CELLS w/ "DIV/0" MACRO 4
Problem with plot 2
Div 0 help 1
#DIV/0! ERROR 2

Top