Forum Discussion

Frank Spade's avatar
Frank Spade
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's avatar
    SergeiBaklan
    Apr 09, 2022

    Frank Spade 

    As variant

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

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 09, 2022

Frank Spade 

As variant

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

 

  • Frank Spade's avatar
    Frank Spade
    Copper Contributor
    Apr 09, 2022

    Thank you.

    What are the spaces for? It works well without.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Apr 09, 2022

      Frank Spade , you are welcome.

      Spaces are for better readability, that's up to you use them or not. Doesn't affect calculations.

      • Frank Spade's avatar
        Frank Spade
        Copper Contributor
        Apr 09, 2022
        Sorry, it looks weird to me. Who said, its better readable? I didn't learn it at the university.
        Thanks anyway.

Resources