How to negate 'isblank' function

Question

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?

pnuts · Accepted Answer · 2017-01-23T20:45:41.590

158

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.

edited Jan 23 '17 at 20:45

answered Sep 24 '14 at 22:40

pnuts

58,317
11
87
139

score 14 · Answer 2 · answered Sep 24 '14 at 11:16

14

The solution is isblank(cell)=false

answered Sep 24 '14 at 11:16

cja

9,512
21
75
129

1

Nah, too much typing. `ISBLANK(cell)=0` – General Grievance Sep 16 '20 at 17:39
1

@Calculuswhiz only `false` seems to work in conditional formatting with custom formulas – Brian Leishman Jul 07 '21 at 21:50
@BrianLeishman Interesting. I guess `NOT(ISBLANK(...))` would be a bit better for that then. – General Grievance Jul 08 '21 at 11:56

score 9 · Answer 3 · edited Aug 04 '16 at 14:30

9

If you're trying to just count how many of your cells in a range are not blank try this:

=COUNTA(range)

Example: (assume that it starts from A1 downwards):

---------    
Something 
---------
Something
---------

---------
Something
---------

---------
Something
---------

=COUNTA(A1:A6) returns 4 since there are two blank cells in there.

edited Aug 04 '16 at 14:30

marikamitsos

10,264
20
26

answered Jun 09 '15 at 14:33

Josh P

1,325
14
12

score 5 · Answer 4 · answered Mar 24 '21 at 12:04

5

IF(ISBLANK(B1),,A1/B1)

OR

NOT(A2)

answered Mar 24 '21 at 12:04

itsazzad

6,868
7
69
89

How to negate 'isblank' function

4 Answers4