如何否定“ isblack”函数

我想做的“不是空白”在一个自定义公式。有一个 isblank()函数，但我既找不到一个 isnotblank()函数，也找不到一种说不的方法，如 !或 ==False。

我怎么说 不是空白的？

143953 次浏览

小开

The solution is isblank(cell)=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.

小开

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.

小开

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

NOT(A2)