Isblank vs CountBlank

M

Mark C

Per the help files in Excel,
CountBlank will count any cell with a "" as blank,
while IsBlank("")=False.
So I don't think your two formulas are truly equal.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
T

T. Valko

So I don't think your two formulas are truly equal.

They're not.

ISBLANK is incorrectly named. It should be named ISEMPTY.

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble with conflicting IsBlank() and CountBlank() results 4
Empty Cells, COUNTBLANK, and ISBLANK 14
Setting Purely BLANK Cell 4
Inserting "true" blanks with functions 5
Multiple CountIF in 1 function 1
lookup 1
IF(ISBLANK) returning #VALUE 6
Nested IF Function 5

Top