Manuals/calci/IS FUNCTIONS

From ZCubes Wiki
Jump to navigation Jump to search
ISFUNCTIONS(n)


  • is the number

Description

  • This function is a group of Information Functions that can be used to find out information about a specific.
  • The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
  • These functions are simple data validation and data type checking functions.

The ISFUNCTIONS are listed below:

  • where is value to check with the function.

The can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.

  • This function will give the result as either TRUE or FALSE according to the value.
  • This function will not convert to numbers from text.
  • Function will consider as string if its written in quotes("").
  • "20" will be not be considered as number since its written inside quotes. So ISNUMBER("20") returns FALSE, because "20" will be considered as string.

Examples

  1. =ISEVEN(28) = TRUE
  2. =ISODD(28) = FALSE
  3. =ISNUMBER(A) = FALSE
  4. =ISBLANK(0) = FALSE
  5. =ISERROR(3/0) = TRUE
  6. =ISERR(2*6) = FALSE
  7. =ISNONTEXT(121*56) = TRUE

Related Videos

IS FUNCTIONS

See Also

Description

Is Function