Menu
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?
559
The IF... The Excel ISBLANK function returns TRUE when a cell is empty, and FALSE when a cell is not empty. For example, if A1 contains "apple", ISBLANK(A1) returns FALSE.
As per previous comments, ISBLANK will return FALSE even if your formula in cell C1 returns an empty string (""). ISBLANK will return TRUE only when a given cell is "truly" blank, i.e. does not contain any formulas or values.
The ISBLANK Function[1] is an Excel Information function that returns true if the argument cell has no information in it. ISBLANK checks a specified cell and tells us if it is blank or not. If it is blank, it will return TRUE; else, it will return FALSE.
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.
200
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
