Manuals/calci/ISBLANK

ISBLANK (Value)


  • is the value to test.
    • ISBLANK(), returns TRUE if the value is blank.

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
  1. =ISBLANK(A1)=FALSE
  2. =ISBLANK(B1)=FALSE
  3. =ISBLANK(C1)=FALSE
  4. =ISBLANK(D1)=TRUE

Related Videos

ISBLANK

See Also

References