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
|
|||
|
|||
not wanting #div/0 to chart as zero
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! |
#2
|
|||
|
|||
not wanting #div/0 to chart as zero
Firstly, I don't understand what you expecting the SUM function to do in
your formula. In what way do you intend SUM(D3+G3) to be different from (D3+G3) ? Is there some subtlety of the SUM function of which we are unaware? If you intended to use =(d3+g3)/c3, you can avoid the DIV/0 by using =IF(C3,(d3+g3)/c3,NA()) -- David Biddulph Brandy wrote: 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! |
#3
|
|||
|
|||
not wanting #div/0 to chart as zero
SUM
When people explore Excel for the first time, they may learn that clicking the big Sigma button creates a formula. If they don't see formulas written by experienced spreadsheet artists, they may think that all formulas start with =SUM. It's the same with old Lotus 1-2-3 users, who often begin every formula with =+, where the + is unnecessary. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "David Biddulph" groups [at] biddulph.org.uk wrote in message ... Firstly, I don't understand what you expecting the SUM function to do in your formula. In what way do you intend SUM(D3+G3) to be different from (D3+G3) ? Is there some subtlety of the SUM function of which we are unaware? If you intended to use =(d3+g3)/c3, you can avoid the DIV/0 by using =IF(C3,(d3+g3)/c3,NA()) -- David Biddulph Brandy wrote: 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! |
Thread Tools | |
Display Modes | |
|
|