Manuals/calci/IS FUNCTIONS

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)
  • 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 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

• ISLOGICAL(n)
• ISEVEN(n)
• ISODD(n)

Description

Is Function