| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I make this display a "0" value
In Cell G18 I have the formula =SUM(G9:G17,-36) but the cells G9-G17 are
blank yet G18 displays a -36 value. I know this must be simple but is there a way to get the G18 cell to display a "0" value if the cells G9-G17 are blank? -- Geo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a 3-dimensional plot in Excel? | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
| How to make this plot? | Charts and Charting in Excel | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Threaded Mode
