Which of these formulas is best for checking if a cell is blank or is there a better way?

[Belinea2010]

Just a quick question for gathering opinions.

I use a macro to insert formulas in cells in a column that are blank, no data what so ever in them, and like everything with Excel there is more than one way of doing things so without getting to technical what would you say is the correct way of doing (and why) or is there a better way?
Baring in mind why I am doing it.

For anyone who is new to Excel, the formulas look at cell A1 and test if it has data or not, and then displays the appropiate message in the cell in which the formula is entered. If you want to run another piece of code if, for example, the cell is blank, you can replace the words "No Data" including the " character with your code.

Method A

Please Login or Register  to view this content.

Method B

Please Login or Register  to view this content.

Method C

Please Login or Register  to view this content.

Method D

Please Login or Register  to view this content.

[AliGW]

I tend to use method A - method C is checking the opposite.

[ChemistB]

Depends on what you are trying to do:
If you have a formula in A1 which is returning null set (""), then Method B will give you "Has Data" because the cell is not blank. Excel sees the "" as text also.
Method D is probably not an option as it will return "No Data" for 0 and negative numbers.
Methods A and C are mirror images of each other so either would work.

[Belinea2010]

I tend to use method A - method C is checking the opposite.

Hi Ali

Many thanks, that was my choice also.

[Belinea2010]

Depends on what you are trying to do:
If you have a formula in A1 which is returning null set (""), then Method B will give you "Has Data" because the cell is not blank. Excel sees the "" as text also.
Method D is probably not an option as it will return "No Data" for 0 and negative numbers.
Methods A and C are mirror images of each other so either would work.

Hi Chemist

Many thanks, Method A is my choice