Changes

Jump to navigation Jump to search
Line 3: Line 3:     
==Description==
 
==Description==
"This function isa 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 IS FUNCTIONS are listed below:
+
*This function is a group of Information Functions that can be used to find out information about a specific.
ISARRAY(n)
+
*The IS FUNCTION is also known as data information functions, data inspection functions or data-testing functions.
ISLEAPYEAR(n)
+
*These functions are simple data validation and data type checking functions.
ISBLANK(n)
+
The ISFUNCTIONS are listed below:
ISERR(n)
+
ISARRAY(n)
ISERROR(n)
+
ISLEAPYEAR(n)
ISLOGICAL(n)
+
ISBLANK(n)
ISNA(n)
+
ISERR(n)
ISNONTEXT(n)
+
ISERROR(n)
ISREF(n)
+
ISLOGICAL(n)
ISTEXT(n)
+
ISNA(n)
ISPMT(n)
+
ISNONTEXT(n)
ISEMPTY(n)
+
ISREF(n)
ISNULL(n)
+
ISTEXT(n)
ISEVEN(n)
+
ISPMT(n)
ISODD(n)
+
ISEMPTY(n)
ISPRIME(n), where n is value to check with the  function.The n can be any type like emptycell, boolean values,text,nontext,number,referencevalue or name referring to any of these.this function will give the result as either TRUE or FALSE according to the n value. This function will not convert any numbers from text. For e.g. ""20"" is normally converted as a number 20. But in ISNUMBER(""20"") will return FALSE, because ""20"" will not convert in to number."
+
ISNULL(n)
 +
ISEVEN(n)
 +
ISODD(n)
 +
ISPRIME(n)
 +
*where n is value to check with the  function.
 +
The n 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 n value.
 +
*This function will not convert any numbers from text.
 +
*For e.g. "20" is normally converted as a number 20. But in ISNUMBER("20") will return FALSE, because "20" will not convert in to number.
    
These are the nine worksheet functions used for testing the type of a value or reference.The function displays 1 or 0 depending on the outcome.
 
These are the nine worksheet functions used for testing the type of a value or reference.The function displays 1 or 0 depending on the outcome.
  −
*=ISLOGICAL(TRUE) is 1
  −
*=ISLOGICAL(“TRUE”) is 0*
  −
*=ISNUMBER(4) is 1
  −
      
'''ISBLANK'''
 
'''ISBLANK'''
writer
5,435

edits

Navigation menu