| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wanting to NOT plot #Div/0 on chart | Charts and Charting in Excel | |||
| Not wanting to plot #div/0 | Charts and Charting in Excel | |||
| I wanting learding office | Excel Discussion (Misc queries) | |||
| Wanting to sum a colum of numbers and then roundup to the next dol | Excel Worksheet Functions | |||
| Wanting to know if this is possible | Excel Discussion (Misc queries) | |||
Threaded Mode
