How to use ISBLANK Function?

[IMA_Saihat]

Hi,
You can use ISBLANK Function in filling blank cells with data in the above cell as in the following formula:

=IF(ISBLANK(A2);B1;A2)

[FDibbins]

OK, is there a question here?

Personally, I prefer doing it this way...
=IF(A2="";B1;A2)

[judgeh59]

I actually go back and forth on this subject....

Ford's technique is quicker for me to type...

IMA's technique has a readable factor that I like...

I have used both techniques...I would be curious if there is a resource factor....does one run faster that the other over a large dataset....

I might test that....

[judgeh59]

There doesn't "seem" to be any decernable time difference between the 2....I tested on a file that had about 290K rows...both took less than 3 seconds to run....interesting....

[FDibbins]

Thanks for the input, judge

I try and use a few functions as practical, but another thing to consider here, is that if A2 contains a formula that returns "", then it is not blank, and the suggested formula will not return the expected results

[judgeh59]

exactly....you do have to know your data set.....

thanks Ford

[Addiaz]

Thanks all ya guys, i always copy one by one >_<, now no more copy.

[Tony Valko]

Based on its characteristics the ISBLANK function should have been named ISEMPTY.

That's how you should interpret it.

[HankW501]

I had tried something similar to that in the original post of this thread on some cells that had been emptied using the ClearContents VBA Method, and for some reason it didn't recognize the cells as blank. Then on a hunch I tried...

Please Login or Register  to view this content.

... and it worked.