#1   Report Post  
Posted to microsoft.public.excel.misc
Mike D.
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Mike D.
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return a cell contents as the result of usiing "small" KFEagle Excel Worksheet Functions 1 September 10th 05 08:33 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
if the value of a cell in a range is not blank, then return the v. kvail Excel Worksheet Functions 2 April 8th 05 10:07 PM
How do I set a cell to "Empty" so that it does not display in a ch Ian Charts and Charting in Excel 3 January 7th 05 02:12 AM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 02:01 PM


All times are GMT +1. The time now is 11:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"