zero blank

I have a line graph where the data is continuously populated from data from another spreadsheet as it comes in. An example of the formula I am using is =+'683 LWN'!F7 What formula would I use to make these cells disregard the zeros that are at the end of the data set (disregard the zero in July...

Greetings all - I have looked high and low and can see that a lot of people have asked about how to keep a line chart from plotting blank cells, but I seem not to be able to nail it down in any effective manner. I have a column that is 25k rows. Each cell has a formula that produces a...

Hi, I have one cell in my spreadsheet "1" that doesn't react to formatting. In the spreadsheet "1" there are many cells that have links to another spreadsheet "2" and if the values in that spreadsheet "2" are zero then by using cell formatting in the spreadsheet "1" instead of values "0" there...

Hi Folks Trying to create a Subtotal average percentage. So we get new averages based on different filtered criteria. Many of the cells are blank. How ca we generate the subtotal average and ignore those blank/zero cells? My current formula is as follows =SUBTOTAL(101,J7,J8766). Totally...

Hello, I need to keep my numbers in thousands (ie. 456,798 as 456.798 or 7,000 as 7). In addition I need to have all cells that equal zero be displayed as dashes "-". How do I format my cells? Thanks!

I have a formula referring to whether another cell is blank (bu way of using ""). However I need "0" and "0.00" to be condidered blank for this purpose. How can I achieve this? Thanks!