I am trying to use a column of data for both graphing and calculations outside of the collumn. Every cell in the collumn is an if() function. I need a value to return to make the cell blank. The "" value won't work because it puts zeros in my graphs, and the na() won't work because the equations used on the collumn are too long to put a if(iserror()) on each argument, so the equation will not calculate with a na() value.

I have worked around this by duplicating all of my collumns in the first collumn I use "" and then use this collumn for the calculations, then the second collumn is =if(A1="", na(), A1). I graph from the second collumn and it is hidden on the spreadsheet.



I don't like this solution, I would prefer if there were a way to make a cell with formula in it treated as though it were actualy blank.

Any Ideas?

Thanks,

Z