Manuals/calci/ISBLANK

ISBLANK(n)

• $n$ is the value to test.

Description

• This function is one of the group in ISFUNCTIONS.
• The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
• ISBLANK function can be used to check for blank or null values.
• This function will return the result as TRUE when given value or referred cell is empty otherwise the result is FALSE when the cell is nonempty.
• The argument can be blank, or it can contain data such as text, numbers, error values, or logical values.

Examples

Spreadsheet

	A	B	C	D
1	121	abc	12/1/2012

• A B C D
• 121 abc 12/1/2012

1. ISBLANK(A1)=FALSE
2. ISBLANK(B1)=FALSE
3. ISBLANK(C1)=FALSE
4. ISBLANK(D1)=TRUE

See Also

• ISLOGICAL
• ISTEXT

References

Correlation