Copy of empty cell gives false on ISBLANK

Hi bmmj

Tested in Numbers (and I assume it will be the same in Excel).

Instead of ISBLANK, use a formula to see if a cell is equal to "" (NULL)

Formula in B2 (and fill down) is IF(A2="","NULL","Not NULL")

Formula in A3 is =A2 Also NULL.

A5 contains a space character. It displays as blank, but it is Not NULL.

Regards,

Ian.

For what it's worth Numbers will report the same result.

In your example A2 contains a function, which in your case =A1. A cell that contains a function is not a blank cell.

Remember that 'empty' is not the same as 'blank'.

That is, if you place a space character, say, the cell is not blank. If you erase the cell, then it will be blank. Whether cutting and pasting in a Numbers/Excel/Quattro/Calc spreadsheet, this holds true, and it's easy to copy a blank cell from one place to another where it matters. What result do you get if you COUNT empty cells for that range?

..and one more to look into:

a cell that is formatted many not be considered BLANK

Using what app?

That, then, would be a question best taken up with Microsoft support or in Microsoft's own forums.

Regards.