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.