Hiding zero values

  • Thread starter William von Zangenberg
  • Start date
W

William von Zangenberg

I have a chart with data in Columns C and E. I want the columns to zero out when subtracted (ex:=E2-C2). My issue is I only want zeros in the answer column G to display in the rows with data, not in the rest of the column where I put the formula. Is that possible? Any ideas would be helpful. I can't hide zero values becuase then nothing in the column would display at all. I tried an If Statement but I get a circular reasoning error. HELP!


Submitted via EggHeadCafe - Software Developer Portal of Choice
A C# WaveOut API Player - Recorder Library
http://www.eggheadcafe.com/tutorial...228-b3afed3f91cd/a-c-waveout-api-player-.aspx
 
S

Shane Devenshire

Hi,

Are you suggesting that if 0 appears because there are values in E2 and C2
which are equal you want them to display. If on the other hand E2 and C2
were blank (or both 0?) you want the 0 not to display?

IF blanks then:
=IF(AND(C2="",E2=""),"",E2-C2)
IF zero values in both cells then:
=IF(AND(C2=0,E2=0,LEN(C2)>0,LEN(E2)>0),"",C2-E2)
or you can combine the two.

Of course, like Benard said, a little more info would help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zero values as gap in a chart 1
Chart to display zeroes values 1
hiding zero values in stacked bar charts 3
Can't use NA() instead of "" but then pb in chart with zero values 3
how do I setup a pie chart that does not plot zero values ? 1
Working with Excel to control stock 1
filling 2D array with no-zero values 3
Making a worksheet and a graph that doesn't show zero values 1

Top