Forum Discussion

Copper Contributor

Apr 09, 2022

Solved

How to determine if there is a non-empty cell in a range

I have tried for over an hour to find a solution to this simple question and finally give up. ISBLANK(A1:AD3) gave an overflow warning. Can somebody please tell me the answer?

excel

Formulas and Functions

SergeiBaklan

Apr 09, 2022

Frank Spade

As variant

=IF( SUM(--NOT(ISBLANK(A1:AD3) ) ), "have some", "all are blank" )

SergeiBaklan

Diamond Contributor

Apr 09, 2022

Frank Spade

As variant

=IF( SUM(--NOT(ISBLANK(A1:AD3) ) ), "have some", "all are blank" )