A table containing a complete reference to the functions supported by JSpreadsheet is displayed below. Detailed description of each function can be found by clicking on the function's name.

Name	Description
ABS	Return the absolute (non-negative) value of the specified number.
ACOS	Returns the arccosine, or inverse cosine, of the specified number. The arccosine is the angle whose cosine is the specified number. The returned angle is given in radians in the range [0…π].
ACOSH	Returns the inverse hyperbolic cosine of the specified number. The inverse hyperbolic cosine is the value whose hyperbolic cosine is n, so ACOSH(COSH(n)) equals n.
ADDRESS	Returns the address of a cell with the specified column and row as text.
AND	Returns TRUE if all of the specified arguments evaluate to TRUE; returns FALSE if one or more of the arguments evaluate to FALSE.
ARABIC	Converts the specified Roman numeral to an Arabic numeral.
ASIN	Returns the arcsine, or inverse sine, of the specified number. The arcsine is the angle whose sine is the specified number. The returned angle is given in radians in the range [-π/2…π/2].
ASINH	Returns the inverse hyperbolic sine of the specified number. The inverse hyperbolic sine is the value whose hyperbolic sine is n, so ASINH(SINH(n)) equals n.
ATAN	Returns the arctangent, or inverse tangent, of the specified number. The arctangent is the angle whose tangent is the specified number. The returned angle is given in radians in the range [-π/2…π/2].
ATAN2	Returns the arctangent, or inverse tangent, of the specified x-coordinates and y-coordinates. The arctangent is the angle from the x-axis to a line containing the origin (0, 0) and a point with the specified coordinates. The angle is given in radians between (-π…π].
ATANH	Returns the inverse hyperbolic tangent of the specified number. The inverse hyperbolic tangent is the value whose hyperbolic tangent is n, so ATANH(TANH(n)) equals n.
AVERAGE	Returns the average of the specified arguments.
AVERAGEIF	Returns the average of the specified arguments.
BASE	Converts the specified number into a text representation with the give base.
BIN2DEC	Converts the specified binary (base 2) number to its decimal equivalent.
BIN2HEX	Converts the specified binary (base 2) number to its hexadecimal equivalent.
BIN2OCT	Converts the specified binary (base 2) number to its octal (base 8) equivalent.
BITAND	Returns the bitwise 'AND' of the specified numbers.
BITLSHIFT	Returns the value of the specified argument shifted to the left by the specified number of bits.
BITOR	Returns the bitwise 'OR' of the specified numbers.
BITRSHIFT	Returns the value of the specified argument shifted to the right by the specified number of bits.
BITXOR	Returns the bitwise 'XOR' of the specified numbers.
CEILING	Rounds the specified number up, away from zero, to the nearest multiple of the specified value.
CHAR	Returns the character represented by the specified numeric value.
CHOOSE	Returns a value from the specified list of values based on the specified index.
CODE	Returns the numeric value corresponding to the first character of the specified text value.
COLUMN	Returns the column number or numbers of the specified cell reference.
COLUMNS	Returns the number of columns in the specified range or array.
COMBIN	Returns the number of combinations for the specified number of items.
CONCATENATE	Joins the specified text values into a single text value.
COS	Returns the cosine of the specified angle.
COSH	Returns the hyperbolic cosine of the specified number.
COUNT	Counts the numbers in the specified cell, cells, and lists.
COUNTA	Counts the number of cells that are not empty in the specified cell or cells, and the items in the lists.
COUNTBLANK	Counts the empty cells in the specified ranges of cells.
COUNTIF	Counts the number of cells in the specified range that meet the specified criterion.
DATE	Constructs a date from the specified year, month and day of the month.
DATEDIF	Returns the difference in years, months, or days between the specified dates.
DAVERAGE	Returns the average of the values in the specified column of the specified database that match the specified criteria.
DAY	Returns the day of the month of the specified date.
DAYS	Returns the number of days between the specified dates.
DAYS360	Returns the number of days between the specified two dates based on a 360-day year (twelve 30-day months).
DB	Returns the depreciation allowance of an asset for the specified period using the fixed-declining balance method.
DCOUNT	Counts the cells that contain numbers in the specified column of the specified database that match the specified criteria.
DCOUNTA	Counts the nonblank cells in the specified column of the specified database that match the specified criteria.
DDB	Returns the depreciation of an asset for the specified period using the double-declining balance method or a custom declination method.
DEC2BIN	Converts the specified decimal number to its binary equivalent.
DEC2HEX	Converts the specified decimal number to its hexadecimal equivalent.
DEC2OCT	Converts the specified decimal number to its octal (base 8) equivalent.
DECIMAL	Converts specified text representing a number in the specified base into a base 10 number.
DEGREES	Converts the specified value from radians to degrees.
DELTA	Checks whether the specified values are equal.
DGET	Extracts a single value from the specified column of the specified database that matches the specified criteria.
DMAX	Returns the largest number in the specified column of the specified database that matches the specified criteria.
DMIN	Returns the smallest number in the specified column of the specified database that matches the specified criteria.
DPRODUCT	Returns the product of the values in the specified column of the specified database that match the specified criteria.
DSTDEV	Estimates the standard deviation based on a sample by using the numbers in the specified column of the specified database that match the specified criteria.
DSTDEVP	Calculates standard deviation based on the entire population by using the numbers in the specified column of the specified database that match the specified criteria.
DSUM	Returns the sum of the values in the specified column of the specified database that match the specified criteria.
DVAR	Calculates the sample variance of the values in the specified column of the specified database that match the specified criteria.
DVARP	Calculates the variance of the values in the specified column of the specified database that match the specified criteria.
EDATE	Returns the date that is the specified number of months before or after the specified date.
EOMONTH	Returns a date representing the last day of the month that is the specified number of months before or after the specified date.
ERROR.TYPE	Returns a number corresponding to the specified error value.
EVEN	Returns the specified number rounded up to the nearest even integer.
EXACT	Checks whether the specified text values are equal using case-sensitive comparison.
EXP	Returns e raised to the specified power.
FACT	Returns the factorial of the specified number.
FACTDOUBLE	Returns the double factorial of the specified number.
FALSE	Returns the logical constant FALSE.
FIND	Searches for the specified string in another string and returns the found position or an error.
FLOOR	Rounds the specified number down, towards zero, to the nearest multiple of the specified value.
FORMULA	Returns the formula at the specified cell reference as text.
FV	Returns a value specifying the future value of an annuity based on the specified periodic, fixed payments and fixed interest rate.
GCD	Returns the greatest common divisor (GCD) of the specified sequence of numbers.
GESTEP	Returns 1 if the specified number is greater than or equal to the specified step; otherwise returns 0.
HEX2BIN	Converts the specified hexadecimal number to its binary equivalent.
HEX2DEC	Converts the specified hexadecimal number to its decimal equivalent.
HEX2OCT	Converts the specified hexadecimal number to its octal (base 8) equivalent.
HLOOKUP	Searches for a value in the top row of the specified table or array of values, and returns a value in the same column from another specified row in the table or array.
HOUR	Returns the hour component [0…23] of the specified time.
HYPERLINK	Creates a hyperlink that opens a document, a web page, or an e-mail client, or jumps to a cell in the current worksheet.
IF	Returns one of two specified values if the specified condition evaluates to TRUE, and the other value if the condition evaluates to FALSE.
IFERROR	Returns the specified value unless it is an error, in which case returns the specified alternative value.
IFNA	Returns the specified value unless it is the #N/A error value, in which case returns the specified alternative value.
INDEX	Returns the value with the specified row and column from the specified cell range or table.
INDIRECT	Returns the reference represented by the specified text.
INT	Rounds the specified number down to the nearest integer.
IRR	Returns the internal rate of return for the specified series of cash flows.
ISBLANK	Checks whether the specified reference identifies an empty cell.
ISERR	Checks whether the specified value is an error value, other than #N/A.
ISERROR	Checks whether the specified value is an error.
ISEVEN	Checks whether the specified number is even.
ISFORMULA	Checks whether the cell identified by the specified reference contains a formula.
ISLOGICAL	Checks whether the specified value is Logical.
ISNA	Checks whether the specified value is the #N/A error value.
ISNONTEXT	Checks whether the specified value refers to any item that is not text, including blank cells.
ISNUMBER	Checks whether the specified value is numeric.
ISODD	Checks whether the specified number is odd.
ISREF	Checks whether the specified value is a cell reference.
ISTEXT	Checks whether the specified value refers to any item that is text.
LCM	Returns the least common multiplier (LCM) of the specified sequence of numbers.
LEFT	Returns the specified number of characters from the left of the specified text.
LEN	Returns the number of characters in the specified text.
LN	Returns the natural logarithm of the specified number.
LOG	Returns the logarithm of the specified number to the specified base.
LOG10	Returns the base-10 logarithm of the specified number.
LOOKUP	Looks for the specified value in the specified list of values and returns the corresponding result.
LOWER	Converts the specified text to lowercase.
MATCH	Returns the position of an item in the specified list that matches the specified value in the specified order.
MAX	Returns the largest from the specified arguments.
MAXA	Returns the largest from the specified arguments, including logical and text values.
MEDIAN	Returns the median (middle value) of the specified arguments.
MID	Returns the specified number of characters from the specified text, starting at the specified position.
MIN	Returns the smallest from the specified arguments.
MINA	Returns the smallest from the specified arguments, including logical and text values.
MINUTE	Returns the minute component [0…59] of the specified time.
MMULT	Returns the matrix product of the specified arrays.
MOD	Returns the reminder of the division of the specified number.
MONTH	Returns the month of the specified date.
MROUND	Returns the specified number rounded to the specified multiple.
MUNIT	Returns the identity matrix with the specified dimension.
N	Converts the specified value to number.
NA	Returns the error value #N/A.
NETWORKDAYS	Returns the number of whole working days between the specified two dates.
NOT	Returns the logical NOT of the specified argument.
NOW	Returns the current system date and time.
NPER	Returns the number of periods for the specified investment based on the specified periodic, constant payments and the specified constant interest rate.
NPV	Returns the net present value of an investment based on the specified series of periodic cash flows and the specified discount rate.
OCT2BIN	Converts the specified octal (base 8) number to its binary (base 2) equivalent.
OCT2DEC	Converts the specified octal (base 8) number to its decimal equivalent.
OCT2HEX	Converts the specified octal (base 8) number to its hexadecimal equivalent.
ODD	Returns the specified number rounded up to the nearest odd integer.
OFFSET	Returns a reference to a range that is the specified number of rows and columns from the specified cell or range of cells. The reference that is returned can be a single cell or a range of cells, according to the specified number of rows and columns.
OR	Returns TRUE if any of the specified arguments evaluate to TRUE; returns FALSE if all arguments evaluate to FALSE.
PERMUT	Returns the number of permutations for the specified number of objects that can be selected from another specified number of objects.
PI	Returns the approximate value of π (pi).
PMT	Calculates the payment for a loan based on the specified constant payments and the specified constant interest rate.
POWER	Returns the specified number raised to the specified power.
PRODUCT	Returns the product of the specified arguments.
PROPER	Capitalizes the first letter in the specified text and any other letters that follow a character other than a letter. Converts all other letters to lowercase letters.
PV	Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now.
QUOTIENT	Returns the integer portion of the division.
RADIANS	Converts the specified value from degrees to radians.
RAND	Returns an evenly distributed random number in the interval [0…1).
RANDBETWEEN	Returns a random integer number in the specified range.
RATE	Returns the interest rate per period of an annuity.
REPLACE	Returns the specified text where the characters at the specified position are replaced with another specified text.
REPT	Returns the specified text repeated the specified number of times.
RIGHT	Returns the specified number of characters from the right of the specified text.
ROMAN	Converts the specified Arabic numeral to its Roman equivalent.
ROUND	Returns the specified number, rounded to the specified number of digits.
ROUNDDOWN	Returns the specified number, rounded down (towards zero) to the specified number of digits.
ROUNDUP	Returns the specified number, rounded up (away from zero) to the specified number of digits.
ROW	Returns the row number or numbers of the specified cell reference.
ROWS	Returns the number of rows in the specified range or array.
SEARCH	Returns the position at which the specified text is found in another specified text, starting at the specified position.
SECOND	Returns the second component [0…59] of the specified time.
SHEET	Returns the sheet number of the specified cell reference or sheet name.
SHEETS	Returns the number of sheets in the specified cell reference.
SIGN	Returns the sign of the specified number.
SIN	Returns the sine of the specified angle.
SINH	Returns the hyperbolic sine of the specified number.
SLN	Returns the straight-line depreciation of an asset for one period.
SQRT	Returns the square of the specified number.
SQRTPI	Returns the square root of the specified number multiplied by π (pi).
STANDARDIZE	Returns the normalized value from a distribution characterized by the specified arguments.
STDEV	Estimates standard deviation based on the specified set of numbers.
STDEVP	Calculates standard deviation based on the entire population given as arguments.
SUBSTITUTE	Returns a modification of the specified text where all occurrences of a text are replaced with another text.
SUBTOTAL	Returns the subtotal of the specified arguments.
SUM	Returns the sum of the specified arguments.
SUMIF	Returns the sum of the cells in the specified range that meet the specified criterion.
SUMPRODUCT	Returns the sum of the products of the values in the specified arrays.
SUMSQ	Returns the sum of the squares of the specified arguments.
SYD	Returns the sum-of-years'-digits depreciation of an asset for the specified period.
T	Returns the text of the specified value.
TAN	Returns the tangent of the specified angle.
TANH	Returns the hyperbolic tangent of the specified number.
TEXT	Converts the specified numeric value to text, according to the specified format.
TIME	Returns a new time value with the specified hours, minutes, and seconds.
TODAY	Returns the current date.
TRIM	Removes all leading and trailing whitespaces from the specified text.
TRUE	Returns the logical constant TRUE.
TRUNC	Truncates the specified number to the specified number of digits.
TYPE	Returns a number indicating the type of the specified value.
UPPER	Converts the specified text to uppercase.
VALUE	Converts the specified text that represents a number to a number.
VAR	Calculates the sample variance of the specified arguments.
VARP	Computes the variance of the specified arguments.
VLOOKUP	Searches for a value in the first column of the specified table or array of values, and returns a value in the same row from another specified column in the table or array.
WEEKDAY	Returns a value indicating the day of the week of the specified date.
WEEKNUM	Returns the number of the week of the specified date, relative to the year.
WORKDAY	Returns the date which is the specified number of work days before or after another specified date.
YEAR	Returns the year of the specified date.