google-sheets

How to negate 'isblank' function


I want to do "is not blank" in a custom formula. There is a isblank() function but I can find neither an isnotblank() function nor a way to say not, such as ! or ==False.

How can I say is not blank?


Solution

  • I suggest:

    =not(isblank(A1))  
    

    which returns TRUE if A1 is populated and FALSE otherwise. Which compares with:

    =isblank(A1)  
    

    which returns TRUE if A1 is empty and otherwise FALSE.