What I want to do is be able to make a formula that references a blank cell, that returns a blank cell.
So I have =A1. If A1 is blank that returns a 0. I want it to return an blank. Is there a way to do that?
I want to make a graph where I have numbers and cells that are blank. Right now I have numbers and zeros so when my data stops the graphs jumps down to zero and stay there.
Hope that's clear, thanks!
Bookmarks