Information Formulas in JQuery Calculate widget
26 Sep 20165 minutes to read
CELL
The Cell
function returns information about a given cell. This can be information in relation to the contents, formatting, or location of the cell.
Syntax:
CELL( infoType, reference)
where:

infoType argument is a text string that specifies the type of information to be returned.

reference is the cell for which the information is to be returned.
ERROR.TYPE
Error.Type
function returns an integer for the given error value that denotes the type of given error.
Syntax:
= ERROR.TYPE(value)
 ValueThe given value is required.
Here is the:
Return Value of Function
Given Value  Return Value Of Function 

#NULL!  1 
#DIV/0!  2 
#VALUE!  3 
#REF!  4 
#NAME?  5 
#NUM!  6 
#N/A  7 
#GETTING_DATA  8 
Anything else  #N/A 
ISBLANK
The IsBlank
function checks for blank or null values.
Syntax:
ISBLANK(value)
where:
 value is the value that you want to test. When the value is blank, this function returns
true
. When the value is not blank, the function returnsfalse
.
ISERR
The IsErr
function checks whether a value is an error.
Syntax:
ISERR( value )
where:
 value is the value that you want to test. When the value is an error value
except #N/A
, this function returnstrue/false
to indicate whether a value is an error or not.
ISERROR
Returns true
when the value is a string that starts with a #
.
Syntax:
ISERROR(value)
where:
 value is the value that is to be tested.
ISLOGICAL
The IsLogiacl
function checks whether a value is a logical value and returns true
or false
.
Syntax:
ISLOGICAL( value )
where:
 This value is the value that you want to test. When the value is a
true
orfalse
value, this function returnstrue
. Otherwise, it returnsfalse
.
ISNA
The IsNA
function returns a Boolean value after determining that the provided value is #NA
error value.
Syntax:
ISNA(value)
where:
 value is the function that is tested.
ISNONTEXT
The IsNonText
function returns the Boolean value after determining that the provided value is not a string.
Syntax:
IsNonText(text)
where:
 text is the value you want to test whether it is a string or not.
ISNUMBER
Returns true
when the value parses as a numeric value.
Syntax:
ISNUMBER(value)
where:
 value is the value that is to be tested.
INFO
The Info
function returns a text string containing information about the current operating environment.
Syntax:
INFO(infoType)
where:
 infoType argument is a text string that specifies the type of information to be returned.
ISFORMULA
The IsFormula
function returns true
or false
when there is a reference to a cell that contains a formula.
Syntax:
ISFORMULA (reference)
where:
 Reference is a reference to the cell you want to test.
Remark:
#VALUE!
occurs when reference is not a valid data type.
ISODD
IsOdd
function returns true
when the given number is an odd number and returns false
when the given number is even.
Syntax:
= ISODD (value)
 The given value must be a numeric value. When it is a noninteger value, the value is rounded down.
ISEVEN
The ISEVEN
function returns TRUE
if given number is an even number and returns FALSE
if the given number is an odd number.
Syntax:
ISEVEN (value)
where:
 value must be a numeric value. If it is noninteger value, the value is rounded down.
Remarks:
 If the given value is nonnumeric, ISEVEN function returns
#VALUE!
error value.
ISREF
The ISREF
function returns the logical value TRUE
if the given value is a reference value; otherwise, the function returns FALSE
.
Syntax:
ISREF(given_value)
 given_value: Required. The value that is to be tested. The value argument can be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these.
MATCH
The MATCH
function searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Syntax:
MATCH(lookup_value, lookup_array, [match_type])
Where:

lookup_value is the value that you want to match in lookup_array.

lookup_array is the range of cells being searched.

match_type specifies how Excel matches lookup_value with values in lookup_array. The default value for this argument is 1.
Match_type Behavior 0 or omitted MATCH finds the largest value that is less than or equal to lookup_value. The lookup_array argument must be placed in ascending order. 0 MATCH finds the first value that is exactly equal to lookup_value. The lookup_array argument can be in any order. 1 MATCH finds the smallest value that is greater than or equal to lookup_value. The lookup_array argument must be placed in descending order.
N
The N
function converts the given value into a numeric value.
Syntax:
N (value)

A value is required.

Numeric values are converted as numeric values. A date value is converted as a serial number. The Logic operator
TRUE
returns a value of1
. The other values are returned as0
.
NA
The NA
function returns the #N/A
error. This error message is produced when a formula is unable to find a value that it needs. This error message denotes ‘value not available’.
Syntax:
NA()
 The NA function syntax has no arguments.
Remarks:
 The function does not have any arguments.
SHEET
The Sheet
function returns the sheet number of the reference sheet.
Syntax:
SHEET(value)
where:
 value is an optional argument with the name of a sheet for which you want the sheet number.
Remarks:

#REF!
 occurs if value argument is not a valid value. 
#N/A
 occurs if value argument is a sheet name that is not valid.
SHEETS
SHEETS
function returns the number of sheets in a reference.
Syntax:
SHEETS(reference)
where:
 reference is an optional argument with the name of a sheet for which you want to know the number of sheets.
Remarks:

#REF!
 occurs if reference is not a valid value.
TYPE
The TYPE
function receives a value and returns an integer that represents the supplied value’s data type.
Syntax:
TYPE( value )
where:
 value can be input either directly, as a value returned from a formula, or as a reference to a cell that contains a value.
ROW
The ROW
function returns the first row number within a supplied reference, or if no reference is supplied, the function returns the number of the current row in the currently active spreadsheet..
ROW( [reference] )
where:
 reference is an optional argument that you want to return the row number of. If [reference] is omitted, the function returns the row number of the current cell (i.e. the cell that the function is entered into).
ROWS
The ROWS
function takes a range and returns the number of rows that are contained within the range.
Syntax:
ROWS( array )
where:
 array argument is the range in which you want to count the number of rows.