Difference between revisions of "Manuals/calci/IS FUNCTIONS"

From ZCubes Wiki
Jump to navigation Jump to search
 
(8 intermediate revisions by one other user not shown)
Line 24: Line 24:
 
**<math>n</math> refers to text.
 
**<math>n</math> refers to text.
 
*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]]
 
*[[Manuals/calci/ISNUMBER| ISNUMBER(n)]]
−
**n refers to a number.
+
**<math>n</math> refers to a number.
 
*[[Manuals/calci/ISARRAY| ISARRAY(n)]]
 
*[[Manuals/calci/ISARRAY| ISARRAY(n)]]
 
*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]]
 
*[[Manuals/calci/ISLEAPYEAR| ISLEAPYEAR(n)]]
Line 37: Line 37:
 
The <math>n</math> can be any type like empty cell, Boolean values,text,non text,number,reference-value or name referring to any of these.
 
The <math>n</math> 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 <math>n</math> value.
 
*This function will give the result as either TRUE or FALSE according to the <math>n</math> value.
−
*This function will not convert any numbers from text.
+
*This function will not convert to 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.
+
*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==
 +
#=ISEVEN(28) = TRUE
 +
#=ISODD(28) = FALSE
 +
#=ISNUMBER(A) = FALSE
 +
#=ISBLANK(0) = FALSE
 +
#=ISERROR(3/0) = TRUE
 +
#=ISERR(2*6) = FALSE
 +
#=ISNONTEXT(121*56) = TRUE
 +
 
 +
==Related Videos==
 +
 
 +
{{#ev:youtube|V5aOdLfrXls|280|center|IS FUNCTIONS}}
 +
 
 +
==See Also==
 +
*[[Manuals/calci/ISLOGICAL| ISLOGICAL(n)]]
 +
*[[Manuals/calci/ISEVEN| ISEVEN(n)]]
 +
*[[Manuals/calci/ISODD| ISODD(n)]]
 +
 
 +
==Description==
 +
[http://en.wikipedia.org/wiki/Is_functions  Is Function]

Latest revision as of 13:47, 12 June 2015

ISFUNCTIONS(n)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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:

  • ISBLANK(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}  refers to an empty cell.
  • ISERR(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} refers to any error value except #N/A.
  • ISERROR(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}  refers to any error value
  • ISLOGICAL(n)
    •  refers to a logical value.
  • ISNA(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} refers to the NaN error value.
  • ISNONTEXT(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}  refers to any item that is not text.
  • ISREF(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}  refers to a reference.
  • ISTEXT(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}  refers to text.
  • ISNUMBER(n)
    • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n}  refers to a number.
  • ISARRAY(n)
  • ISLEAPYEAR(n)
  • ISPMT(n)
  • ISEMPTY(n)
  • ISNULL(n)
  • ISEVEN(n)
  • ISODD(n)
  • ISPRIME(n)
  • where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} is value to check with the function.

The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle n} 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

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/IS_FUNCTIONS&oldid=201898"