Array returns 0 rather than blank

[scruz9]

Hi Everyone,

I have this array pulling the max value from a table and when a cell in row 4 is blank, i'd like for it to also be blank, but it's returning a zero. The first instance of this can be seen in BX3 and onwards.

Thanks in advance for the help!

[Jonmo1]

The problem is that your testing BX4 with IF(ISBLNK(BX4),""
But BX4 is NOT blank, it contains a formula.
A cell that contains a formula is NOT blank, regardless of what that formula returns. Just the fact that the cell contains a formula makes it NOT blank.

Also, the formula you have in BX4 is returning " ", that's a SPACE.
We generally try to use "" (a zero length text string) to represent the closest thing to blank that we can get.

So change the formula in row 4 from using " " to just ""
Then change the formula in row 3 to test for 'blank' with
IF(BX4="",