Sometimes you need to check if a cell is blank, generally because you might not want a formula to display a result without input. In this case we're using IF with the ISBLANK function:

Use IS functions like ISERROR or ISERR to see if an error condition exists, ISBLANK to check if cells are empty, or ISNUMBER to check if values are numbers.

How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.

在此情況下，我們會使用 IF 搭配 ISBLANK 函數： =IF (ISBLANK (D2),"空白","非空白") 這表示 IF (D2 空白則傳回 "空白"，相反則傳回 "非空白")。 您也可以在自己的公式輕鬆運用 "非空白" 條件。 在下一 …

Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).

Lists all Information functions, such as the INFO, ISBLANK, and ISTEXT functions.

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down …

使用 IS 函數 (如 ISERROR 或 ISERR) 檢查是否存在錯誤情況、使用 ISBLANK 檢查儲存格是否為空白，或使用 ISNUMBER 函數檢查值是否為數字。

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The …

在此情況下，我們會使用 IF 搭配 ISBLANK 函數： =IF (ISBLANK (D2),"空白","非空白") 這表示 IF (D2 空白則傳回 "空白"，相反則傳回 "非空白")。 您也可以在自己的公式輕鬆運用 "非空白" 條件。 在下一 …