Checks whether a reference is to an empty cell and returns TRUE or FALSE.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
ISBLANK(value)The ISBLANK function determines if a specific cell reference contains no data. It returns TRUE if the cell is completely empty, and FALSE if the cell contains a value, a formula, or even an empty string result from a formula.
=ISBLANK(A1)תוצאה: TRUE
Returns TRUE if cell A1 is empty.
=ISBLANK("")תוצאה: FALSE
Returns FALSE because an empty string is considered a value.
No, a cell containing a space is not considered empty, so it returns FALSE.