offset function in ecel 2010
I am creating a dynamic chart in excel 2010. I am using the offset function that will cover a range of cells. The problem is that the range has some if functions that may return nothing. ie =IF(4>5,11,"") The offset is still picking up the field. So is nothing eg "" something. Any idea how to get around the problem.