Return an empty cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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).
 
Thanks, Dave. That works great!

Dave Peterson said:
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).
Click to expand...
 
Back
Top