| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Linking to a data range containing blank cells
I'm using MS Excel 2003.
I've got a chart from range of data gives the calculates accumulated total from another table and would like the option to have the calculation result in a blank cell that is not plotted as a zero. I tried the following IF statement: =IF(Q6="","",Q6+P12) but "" is still treated as a zero. Any suggestions? Thanks, - James |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Linking to a data range containing blank cells
=IF(Q6="",NA(),Q6+P12)
-- David Biddulph "James from Sage" wrote in message ... I'm using MS Excel 2003. I've got a chart from range of data gives the calculates accumulated total from another table and would like the option to have the calculation result in a blank cell that is not plotted as a zero. I tried the following IF statement: =IF(Q6="","",Q6+P12) but "" is still treated as a zero. Any suggestions? Thanks, - James |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Linking to a data range containing blank cells
Works perfectly, thanks David!
"David Biddulph" wrote: =IF(Q6="",NA(),Q6+P12) -- David Biddulph "James from Sage" wrote in message ... I'm using MS Excel 2003. I've got a chart from range of data gives the calculates accumulated total from another table and would like the option to have the calculation result in a blank cell that is not plotted as a zero. I tried the following IF statement: =IF(Q6="","",Q6+P12) but "" is still treated as a zero. Any suggestions? Thanks, - James |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If certain cells not blank, and cells in range are, set values to | Excel Discussion (Misc queries) | |||
| Linking a range of cells | Excel Discussion (Misc queries) | |||
| Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
| Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions | |||
| How do I skip blank cells when copying over a range of cells? | Excel Discussion (Misc queries) | |||
Linear Mode
