I am running a program called Aspen, which return a set of data in a column with numbers or blank.
Say, Column A1 to A10 are numbers, except A9- which appeared to be a Blank.
When I use the ISblank function on A9, it returned as not a blank or zero.
When I try to use Max (A1 to A10) or Avg (A1 to A10), I have got an error in return.
How can I make the return cell from Aspen as a truly blank?
Say, Column A1 to A10 are numbers, except A9- which appeared to be a Blank.
When I use the ISblank function on A9, it returned as not a blank or zero.
When I try to use Max (A1 to A10) or Avg (A1 to A10), I have got an error in return.
How can I make the return cell from Aspen as a truly blank?