If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
wanting to NOT plot #Div/0 on chart
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! |
#2
|
|||
|
|||
wanting to NOT plot #Div/0 on chart
Asking 3 times in no more likely (in fact probably less likely) to give you
an answer than asking once. -- David Biddulph Brandy wrote: 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! |
Thread Tools | |
Display Modes | |
|
|