| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return an empty cell
The following formula will return an empty value if the condition is true:
=IF(SUM(C3:E3)=0,"",(C3+D3)/SUM(C3:E3)) My problem is that when I go to chart the data, the chart treats this entry as zero. I have the options set to leave gaps for empty cells, but it still treats this entry as zero instead of empty. Is there a way I can have my formula truly return an empty cell so it will not be plotted? Thank,s Mike. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return an empty cell
You could try:
=IF(SUM(C3:E3)=0,na(),(C3+D3)/SUM(C3:E3)) Then use conditional formatting to hide that error (so it's prettier). Mike D. wrote: The following formula will return an empty value if the condition is true: =IF(SUM(C3:E3)=0,"",(C3+D3)/SUM(C3:E3)) My problem is that when I go to chart the data, the chart treats this entry as zero. I have the options set to leave gaps for empty cells, but it still treats this entry as zero instead of empty. Is there a way I can have my formula truly return an empty cell so it will not be plotted? Thank,s Mike. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return an empty cell
Thanks, Dave. That works great!
"Dave Peterson" wrote: You could try: =IF(SUM(C3:E3)=0,na(),(C3+D3)/SUM(C3:E3)) Then use conditional formatting to hide that error (so it's prettier). Mike D. wrote: The following formula will return an empty value if the condition is true: =IF(SUM(C3:E3)=0,"",(C3+D3)/SUM(C3:E3)) My problem is that when I go to chart the data, the chart treats this entry as zero. I have the options set to leave gaps for empty cells, but it still treats this entry as zero instead of empty. Is there a way I can have my formula truly return an empty cell so it will not be plotted? Thank,s Mike. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return a cell contents as the result of usiing "small" | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Linear Mode
