### List of available functions (ver. 0.9.4)

Function | Type | Arguments | Syntax | Description |
---|---|---|---|---|

ABS | Math | - number | ABS(number) | Returns the absolute value of a number. |

ACCRINT | Financial | - first - settlement - rate - par - frequency - basis - method | ACCRINT(issue, first, settlement, rate, par, frequency, basis, method) | Calculates the accrued interest for a security that pays interest on a periodic basis. |

ACCRINTM | Financial | - issue - settlement - rate - par - basis | ACCRINTM(issue, settlement, rate, par, basis) | Calculates the accrued interest for a security that pays interest on maturity. |

ACOS | Math | - number | ACOS(number) | Returns the arccosine of a number (in radians). |

ACOSH | Math | - number | ACOSH(number) | Returns the inverse hyperbolic cosine of a number. |

ACOT | Math | - number | ACOT(number) | Returns the inverse hyperbolic cotangent of a value (in radians). |

ACOTH | Math | - number | ACOTH(number) | Returns the inverse hyperbolic cotangent of a number. |

AGGREGATE | Math | - function_code - arg1 - arg2 ... | AGGREGATE(function_code, arg1, arg2, ...) | Returns a aggregate calculation of selected functions (function code 1-19) |

AMORDEGRC | Financial | - cost - purchased - firstPeriod - salvage - period - rate - basis | AMORDEGRC(cost, purchased, firstPeriod, salvage, period, rate, basis) | Returns the linear depreciation of an asset for each accounting period, on a prorated basis. |

AMORLINC | Financial | - cost - purchased - firstPeriod - salvage - period - rate - basis | AMORLINC(cost, purchased, firstPeriod, salvage, period, rate, basis) | Calculate the depreciation of an asset for each accounting period using a linear depreciation method. |

AND | Logical | - logical1 - [logical2] ... | AND(logical1, [logical2], ...) | Check if all conditions are TRUE. |

ARABIC | Text | - text | ARABIC(text) | Converts a Roman number to Arabic. |

ARGSCONCAT | Text | - args | ARGSCONCAT(args) | Joins 2 or more strings together. |

ASIN | Math | - number | ASIN(number) | Returns the inverse sine of a number (in radians). |

ASIN | Math | - number | ASIN(number) | Returns the inverse sine of a value (in radians). |

ASINH | Math | - number | ASINH(number) | Returns the the nverse hyperbolic sine of a number. |

ATAN | Math | - number | ATAN(number) | Returns the inverse tangent of a number (in radians). |

ATAN2 | Math | - number_x - number_y | ATAN2(number_x, number_y) | Returns the arc tangent of the two numbers (in radians). |

ATANH | Math | - number | ATANH(number) | Returns the inverse hyperbolic tangent of a number (in radians). |

AVEDEV | Statistical | - number1 - [number2] | AVEDEV(number1, [number2], ...) | Average of the absolute deviations of data points from their mean. |

AVERAGE | Statistical | - number1 - [number2] | AVERAGE(number1, [number2], ...) | Returns the average of the arguments. |

AVERAGEA | Statistical | - number1 - [number2] | AVERAGEA(number1, [number2], ...) | Returns the average value in a range of numbers. |

AVERAGEIF | Statistical | - range - criteria - average_range | AVERAGEIF(range, criteria, average_range) | Returns the average of a range depending on criteria. |

AVERAGEIFS | Statistical | AVERAGEIFS() | Returns the average of a range depending on multiple criteria. | |

BASE | Math | - number - radix - min_length | BASE(number, radix, min_length) | Converts a number into a text representation with the given base. |

BESSELI | Math | - x - n | BESSELI(x, n) | Returns the modified Bessel function. |

BESSELJ | Math | - x - n | BESSELJ(x, n) | Returns the Bessel function for a specified order and value of x. |

BESSELK | Math | - x - n | BESSELK(x, n) | Returns the modified Bessel function. |

BESSELY | Math | - x - n | BESSELY(x, n) | Returns the Bessel function, also known as the Weber function or the Neumann function. |

BETADIST | Statistical | - x - alpha - beta - cumulative - A - B | BETADIST(x, alpha, beta, cumulative, A, B) | Returns the cumulative beta probability density function. |

BETAINV | Statistical | - probability - alpha - beta - A - B | BETAINV(probability, alpha, beta, A, B) | Returns the inverse of the cumulative beta probability density function. |

BIN2DEC | Engineering | - number | BIN2DEC(number) | Converts a binary number to a decimal number. |

BIN2HEX | Engineering | - number - places | BIN2HEX(number, places) | Converts a binary number to a hexadecimal format. |

BIN2OCT | Engineering | - number - places | BIN2OCT(number, places) | Converts a binary number to a octal format |

BINOMDIST | Statistical | - successes - trials - probability - cumulative | BINOMDIST(successes, trials, probability, cumulative) | Returns the individual term binomial distribution probability. |

BINOMDISTRANGE | Statistical | - trials - probability - successes - successes2 | BINOMDISTRANGE(trials, probability, successes, successes2) | Returns the Binomial Distribution probability for a number. |

BINOMINV | - trials - probability - alpha | BINOMINV(trials, probability, alpha) | Returns the inverse of the Cumulative Binomial Distribution. | |

BITAND | Engineering | - number1 - number2 | BITAND(number1, number2) | Bitwise boolean AND of two numbers. |

BITLSHIFT | Engineering | - number - shift | BITLSHIFT(number, shift) | Shifts a number by the specified number of bits to the left. |

BITOR | Engineering | - number1 - number2 | BITOR(number1, number2) | Bitwise boolean OR of two numbers. |

BITRSHIFT | Engineering | - number - shift | BITRSHIFT(number, shift) | Shifts a number by the specified number of bits to the right. |

BITXOR | Engineering | - number1 - number2 | BITXOR(number1, number2) | Bitwise XOR of two numbers. |

CHART | Graphical | - xvalues - yvalues - library - type - options | CHART(xvalues, yvalues, library, type, options) | Shows the chart based on the chosen library. |

CHART_SPARKLINES | Graphical | - xvalues - yvalues - type - options | CHART_SPARKLINES(xvalues, yvalues, type, options) | Shows the jQuery.Sparklines chart. |

CHART_RGRAPH | Graphical | - xvalues - yvalues - type - options | CHART_RGRAPH(xvalues, yvalues, type, options) | Shows the RGraph chart. |

CEILING | Math | - number - significance - mode | CEILING(number, significance, mode) | Rounds the number up to the nearest integer of specified significance. |

CEILINGMATH | Math | - number - significance - mode | CEILINGMATH(number, significance, mode) | Rounds a number up to a specified multiple. |

CEILINGPRECISE | Math | - number - significance - mode | CEILINGPRECISE(number, significance, mode) | Rounds a number up to a given multiple. |

CHAR | Text | - number | CHAR(number) | Returns the character based on the corresponding numeric value. |

CHISQDIST | Statistical | - x - k - cumulative | CHISQDIST(x, k, cumulative) | Calculates the right-tailed probability of a chi-square distribution. |

CHISQINV | Statistical | - probability - k | CHISQINV(probability, k) | Calculate the inverse of the left-tailed probability of the chi-square distribution. |

CLEAN | Text | - text | CLEAN(text) | Removes non-printable ASCII characters from string. |

CODE | Text | - text | CODE(text) | Returns the numeric code for the first character of a supplied string. |

COMBIN | Math | - number - number_chosen | COMBIN(number, number_chosen) | Returns the number of combinations for a specified number of items. |

COMBINA | Math | - number - number_chosen | COMBINA(number, number_chosen) | Returns the number of combinations for a specified number of items and includes repetitions. |

COMPLEX | Engineering | - real - imaginary - suffix | COMPLEX(real, imaginary, suffix) | Converts coefficients into a complex number. |

CONCATENATE | Text | - text1 - text2 | CONCATENATE(text1, text2, ...) | Joins together two or more text strings. |

CONFIDENCENORM | - alpha - sd - n | CONFIDENCENORM(alpha, sd, n) | Returns the confidence interval for a population mean, for a supplied probablity and sample size. | |

CONFIDENCET | Statistical | - alpha - sd - n | CONFIDENCET(alpha, sd, n) | Returns the size of a confidence interval for the mean of a sample, using a Students t-distribution. |

CONVERT | Parser | - number - from_unit - to_unit | CONVERT(number, from_unit, to_unit) | Converts a numeric value to a different unit of measure. |

CORREL | Statistical | - number1 - [number2] | CORREL(number1, [number2], ...) | Calculates r, the Pearson product-moment correlation coefficient of the numbers. |

COS | Math | - number | COS(number) | Cosine of a number. The number represents an angle in radians. |

COSH | Math | - number | COSH(number) | Returns the hyperbolic cosine of a number. |

COT | Math | - number | COT(number) | Returns the cotangent of a number (in radians). |

COTH | Math | - number | COTH(number) | Returns the hyperbolic cotangent of a number. |

COUNT | Statistical | - number1 - [number2] | COUNT(number1, [number2], ...) | Counts the number of cells that contain numeric values. |

COUNTA | Statistical | - number1 - [number2] | COUNTA(number1, [number2], ...) | Counts the number of cells in a range of values. |

COUNTBLANK | Math | - range | COUNTBLANK(range) | Counts the empty cells in a range. |

COUNTIF | Math | - range - criteria | COUNTIF(range, criteria) | Counts cells that meet criteria. |

COUNTIFS | Math | - range - criteria1 - [criteria2] - | COUNTIFS(range, criteria1, [criteria2], ...) | Counts the number of cells in a range, that meets a single or multiple criteria. |

COUNTIN | Math | - range - value | COUNTIN(range, value) | Counts the number of cells in a range that contain numbers. |

COUNTUNIQUE | Math | - range | COUNTUNIQUE(range) | Counts how many unique values exist in a range that contains duplicate values. |

COVARIANCEP | Statistical | - array1 - array2 | COVARIANCEP(array1, array2) | Calculates the population covariance of two arrays. |

COVARIANCES | Math | - array1 - array2 | COVARIANCES(array1, array2) | Calculate the sample covariance for two arrays. |

CSC | Math | - number | CSC(number) | Returns the cosecant of a number (in radians). |

CSCH | Math | - number | CSCH(number) | Returns the hyperbolic cosecant of a number (in radians). |

CUMIPMT | Financial | - rate - periods - value - start - end - type | CUMIPMT(rate, periods, value, start, end, type) | Calculates the cumulative interest paid on an investment between two periods based on a specified interest rate and a constant payment schedule. |

CUMPRINC | Financial | - rate - periods - value - start - end - type | CUMPRINC(rate, periods, value, start, end, type) | Calculates the cumulative principal paid on a loan or an investment. |

DATE | Date | - year - month - day | DATE(year, month, day) | Converts a provided year, month, and day into a date. |

DATEDIF | Date | - start_date - end_date - interval | DATEDIF(start_date, end_date, interval) | Returns the difference between two date values in years, months, or days. |

DATEVALUE | Date | - date_text | DATEVALUE(date_text) | Converts a date represented as text into a date. |

DAVERAGE | Database | - database - field - criteria | DAVERAGE(database, field, criteria) | Returns the average in a given field for records that match criteria. |

DAY | Date | - date | DAY(date) | Returns the day of the month as a number between 1 to 31. |

DAYS | Date | - end_date - start_date | DAYS(end_date, start_date) | Returns the number of days between two dates. |

DAYS360 | Date | - start_date - end_date - method | DAYS360(start_date, end_date, method) | Returns the number of days between two dates based on a 360-day year. |

DB | Financial | - cost - salvage - life - period - month | DB(cost, salvage, life, period, month) | Returns the depreciation of an asset for a given time period based on the fixed-declining balance method. |

DCOUNT | Database | - database - field - criteria | DCOUNT(database, field, criteria) | Counts matching values in a database, array or a range using criteria and an optional field. |

DCOUNTA | Database | - database - field - criteria | DCOUNTA(database, field, criteria) | See DCOUNT. |

DDB | Financial | - cost - salvage - life - period - factor | DDB(cost, salvage, life, period, factor) | Returns the depreciation of an asset for a given time period based on the double-declining balance method. |

DEC2BIN | Engineering | - number - places | DEC2BIN(number, places) | Converts a decimal number to binary format. |

DEC2HEX | Engineering | - number - places | DEC2HEX(number, places) | Converts a decimal number to hexadecimal format. |

DEC2OCT | Engineering | - number - places | DEC2OCT(number, places) | Converts a decimal number to octal format. |

DECIMAL | Math | - number - radix | DECIMAL(number, radix) | Converts an alpha-numeric number into its decimal equivalent. |

DEGREES | Math | - number | DEGREES(number) | Converts an angle value in radians to degrees. |

DELTA | Engineering | - number1 - number2 | DELTA(number1, number2) | Compares two numeric values and returns 1 if they're equal. |

DEVSQ | Statistical | - range | DEVSQ(range) | Calculates the sum of the squared deviations from the sample mean. |

DGET | Database | - database - field - criteria | DGET(database, field, criteria) | Returns a single value in a given field from a record that matches criteria. |

DMAX | Database | - database - field - criteria | DMAX(database, field, criteria) | Returns the maximum value in a field, from a set of records that match criteria. |

DMIN | Database | - database - field - criteria | DMIN(database, field, criteria) | Returns the minimum value in a field, from a set of records that match criteria. |

DOLLAR | Text | - number - decimals | DOLLAR(number, decimals) | Formats a number into text, using a currency format. |

DOLLARDE | Financial | - dollar - fraction | DOLLARDE(dollar, fraction) | Converts a dollar value in fractional notation into a decimal notation. |

DOLLARFR | Financial | - dollar - fraction | DOLLARFR(dollar, fraction) | Converts a dollar value in decimal notation into a fractional notation. |

DPRODUCT | Database | - database - field - criteria | DPRODUCT(database, field, criteria) | Returns the product of values from a set of records that match criteria. |

DSTDEV | Database | - database - field - criteria | DSTDEV(database, field, criteria) | Returns the standard deviation of pupulation sample extracted from records that match criteria. |

DSTDEVP | Database | - database - field - criteria | DSTDEVP(database, field, criteria) | Returns the standard deviation for an entire population from records that match criteria. |

DSUM | Database | - database - field - criteria | DSUM(database, field, criteria) | Returns the sum of values from a database, array or range that match criteria. |

DVAR | Database | - database - field - criteria | DVAR(database, field, criteria) | Returns the variance of a sample extracted from records that match criteria. |

DVARP | Database | - database - field - criteria | DVARP(database, field, criteria) | Returns the variance of an entire population extracted from records that match criteria. |

E | Math | E() | Returns the value of E constant to 15 decimal places. | |

EDATE | Date | - start_date - months | EDATE(start_date, months) | Adds a number of months to a date and returns the result as a date. |

EFFECT | Financial | - rate - periods | EFFECT(rate, periods) | Returns the effective annual interest rate, from the nominal annual interest rate. |

EOMONTH | Date | - start_date - months | EOMONTH(start_date, months) | Calculates the last day of the month after adding a number of months to a date. |

ERF | Math | - lower_bound - upper_bound | ERF(lower_bound, upper_bound) | Returns the integral of the Gauss error function over an interval of values. |

ERFC | Math | - x | ERFC(x) | Calculates the Complementary Error Function integrated between a supplied lower limit and infinity. |

ERFCPRECISE | Math | - x | ERFCPRECISE(x) | See ERFC. |

ERFPRECISE | Math | - x | ERFPRECISE(x) | Returns the error function. |

EVEN | Text | - number | EVEN(number) | Rounds a number up to the nearest even integer. |

EXACT | Text | - text1 - text2 | EXACT(text1, text2) | Compares two strings and checks whether they are identical. Returns TRUE or FALSE. |

EXP | Math | EXP() | Returns Euler's number, e (~2.718) raised to a power. | |

EXPONDIST | Statistical | - x - lambda - cumulative | EXPONDIST(x, lambda, cumulative) | Returns the value of the exponential distribution for a given value. |

FACT | Math | - number | FACT(number) | Returns the factorial of a number. |

FACTDOUBLE | Math | - number | FACTDOUBLE(number) | Returns the double factorial of a number. |

FALSE | Logical | FALSE() | Returns the logical value FALSE. | |

FDIST | Statistical | - x - d1 - d2 - cumulative | FDIST(x, d1, d2, cumulative) | Returns the probability of getting less than or equal to a particular value in an left tailed F distribution. |

FIND | Text | - find_text - within_text - position | FIND(find_text, within_text, position) | Returns the position of text inside another one. |

FINDFIELD | Database | - database - title, | FINDFIELD(database, title) | Returns index of column inside database, array or range. |

FINDRESULTINDEX | Database | - database - criteria | FINDRESULTINDEX(database, criteria) | Returns indexes of columns inside database, array or range based on criteria. |

FINV | Statistical | - probability - d1 - d2 | FINV(probability, d1, d2) | Calculates the inverse of the right-tailed F distribution for a given probability. |

FISHER | Statistical | - x | FISHER(x) | Calculates the Fisher Transformation for a given value. |

FISHERINV | Statistical | - y | FISHERINV(y) | Calculates the inverse Fisher Transformation for a given value. |

FIXED | Text | - number - decimals - no_commas | FIXED(number, decimals, no_commas) | Formats a number with a fixed number of decimal places. |

FLATTEN | Math | - array | FLATTEN(array) | Flatten multi-dimensional array to one dimension. |

FLOOR | Math | - number - significance - mode | FLOOR(number, significance, mode) | Rounds a given number down to the nearest specified multiple. |

FLOORMATH | Math | - number - significance - mode | FLOORMATH(number, significance, mode) | Rounds a number down to a specified multiple. |

FLOORPRECISE | Math | - number - significance | FLOORPRECISE(number, significance) | See FLOORMATH. |

FORECAST | Statistical | - x - data_y - data_x | FORECAST(x, data_y, data_x) | Calculates a future value of x based on linear regression of dataset. |

FREQUENCY | Array | - data - bins | FREQUENCY(data, bins) | Returns a frequency distribution. |

FROMNOW | Date | - timestamp - nosuffix | FROMNOW(timestamp, nosuffix) | Returns time that has passed since a given date. |

FV | Financial | - rate - periods - payment - value - type | FV(rate, periods, payment, value, type) | Returns the future value of an investment based on a constant interest rate. |

FVSCHEDULE | Financial | - principal - schedule | FVSCHEDULE(principal, schedule) | Calculates the future value of an investment with a variable interest rate. |

GAMMA | Math | - shape - scale | GAMMA(shape, scale) | Returns the value of the Gamma distribution with the parameters shape (k) and scale (theta). |

GAMMALN | Math | - x | GAMMALN(x) | Returns the Log-Gamma function evaluated at x. |

GAUSS | Statistical | - z | GAUSS(z) | Returns the probability that a member of a standard normal population will fall between the mean and a specified number of standard deviations from the mean. |

GCD | Math | - number1 - [number2] ... | GCD(number1, number2, ...) | Returns the greatest common divisor of two or more integers. |

GEOMEAN | Statistical | - range | GEOMEAN(range) | Returns the geometric mean for a set of numeric values. |

GESTEP | Engineering | - number - step | GESTEP(number, step) | Returns TRUE if a supplied number is greater than a supplied step size or FALSE otherwise. |

GETJSON | File | - file | GETJSON(file) | Returns the entire file in JSON format. |

GROWTH | Math | - known_y - known_x - new_x - use_const | GROWTH(known_y, known_x, new_x, use_const) | Calculates the exponential growth curve through a given set of y-values and optionally a set of x-values. |

HARMEAN | Statistical | - range | HARMEAN(range) | Calculates the harmonic mean of a range. |

HEX2BIN | Engineering | - number - places | HEX2BIN(number, places) | Converts a hexadecimal number to binary format. |

HEX2DEC | Engineering | - number | HEX2DEC(number) | Converts a hexadecimal number to decimal format. |

HEX2OCT | Engineering | - number - places | HEX2OCT(number, places) | Converts a hexadecimal number to octal format. |

HOUR | Date | - date | HOUR(date) | Returns hour from a given date. |

HTML2TEXT | Text | - value | HTML2TEXT(value) | Strips html from text or numbers. |

HYPGEOMDIST | Statistical | - x - n - M - N - cumulative | HYPGEOMDIST(x, n, M, N, cumulative) | Returns the value of the hypergeometric distribution for a given number of successes from a sample of a population. |

IF | Logical | - test - then_value - otherwise_value | IF(test, then_value, otherwise_value) | Checks whether a condition is met and returns one value if true and another value if false. |

IFERROR | Logical | - value - valueIfError | IFERROR(value, valueIfError) | Returns a custom result when a formula generates an error. |

IFNA | Logical | - value - value_if_na | IFNA(value, value_if_na) | Returns a custom value when a formula generates the #N/A error, otherwise returns standard result. |

IMABS | Engineering | - inumber | IMABS(inumber) | Returns the absolute value of a complex number. |

IMAGE | Graphical | - src - mode - width - height - title | IMAGE(src, mode, width, height, title) | Inserts an image from a given url into a cell. |

IMAGINARY | Math | - inumber | IMAGINARY(inumber) | Returns the imaginary coefficient of a supplied complex number. |

IMARGUMENT | Math | - inumber | IMARGUMENT(inumber) | Returns an angle expressed in radians of a complex number. |

IMCONJUGATE | Math | - inumber | IMCONJUGATE(inumber) | Returns the complex conjugate of a complex number. |

IMCOS | Math | - inumber | IMCOS(inumber) | Returns the cosine of a complex number. |

IMCOSH | Math | - inumber | IMCOSH(inumber) | Returns the hyperbolic cosine of a complex number. |

IMCOT | Math | - inumber | IMCOT(inumber) | Returns the cotangent of a complex number. |

IMCSC | Math | - inumber | IMCSC(inumber) | Returns the cosecant of a complex number. |

IMCSCH | Math | - inumber | IMCSCH(inumber) | Returns the hyperbolic cosecant of a complex number. |

IMDIV | Math | - inumber1 - inumber2 | IMDIV(inumber1, inumber2) | Returns division of two complex numbers. |

IMEXP | Math | - inumber | IMEXP(inumber) | Returns the exponential of a complex number. |

IMLN | Math | - inumber | IMLN(inumber) | Returns the natural logarithm of a complex number. |

IMLOG10 | Math | - inumber | IMLOG10(inumber) | Returns the base 10 logarithm of a complex number. |

IMLOG2 | Math | - inumber | IMLOG2(inumber) | Returns the base 2 logarithm of a complex number. |

IMPOWER | Math | - inumber1 - number | IMPOWER(inumber, number) | Returns a complex number raised to a power. |

IMPRODUCT | Engineering | - number1 - [number2] ... | IMPRODUCT(number1, [number2], ...) | Calculates the product of two or more complex numbers. |

IMREAL | Math | - inumber | IMREAL(inumber) | Returns the real coefficient of a complex number |

IMSEC | Math | - inumber | IMSEC(inumber) | Returns the secant of a complex number. |

IMSECH | Math | - inumber | IMSECH(inumber) | Returns the hyperbolic secant of a complex number. |

IMSIN | Math | - inumber | IMSIN(inumber) | Returns the sine of a complex number. |

IMSINH | Math | - inumber | IMSINH(inumber) | Returns the hyperbolic sine of a complex number. |

IMSQRT | Math | - inumber | IMSQRT(inumber) | Returns the square root of a complex number. |

IMSUB | Math | - inumber1 - inumber2 | IMSUB(inumber1, inumber2) | Calculates the difference between two complex numbers. |

IMSUM | Math | IMSUM() | Calculates the sum of two or more complex numbers. | |

IMTAN | Math | - inumber | IMTAN(inumber) | Returns tangent of a complex number. |

INT | Math | - number | INT(number) | Rounds a number down to the nearest integer. |

INTERCEPT | Statistical | - data_y - data_x | INTERCEPT(data_y, data_x) | Calculates the value at the intersection of the y axis of the linear regression line through a set of x- and y- values. |

INTERVAL | Math | - second | INTERVAL(second) | Converts interval given in seconds into years, months, days, hours, minutes and seconds. |

IPMT | Financial | - rate - period - periods - present - future - type | IPMT(rate, period, periods, present, future, type) | Calculates the interest payment, during a specific period of a loan or investment, |

IRR | Financial | - values - guess | IRR(values, guess) | Returns the internal rate of return (IRR) for a series of cash flows that occur at regular intervals. |

ISERR | Info | - value | ISERR(value) | Checks whether a value is an error other than #N/A. |

ISERROR | Info | - value | ISERROR(value) | Checks whether a value is an error. |

ISEVEN | Math | - number | ISEVEN(number) | Checks whether the provided number is even and returns TRUE or FALSE. |

ISNUMBER | Logical | - number | ISNUMBER(number) | Checks whether a value is a number. |

ISOCEILING | Math | - number - significance - mode | ISOCEILING(number, significance, mode) | Rounds a number up, to the nearest multiple of significance. |

ISODD | Math | - number | ISODD(number) | Checks whether the provided number is odd and returns TRUE or FALSE. |

ISOWEEKNUM | Date | - date | ISOWEEKNUM(date) | Returns a week number that follows ISO standards. |

ISPMT | Financial | - rate - period - periods - value | ISPMT(rate, period, periods, value) | Returns the interest payment for an investment based on an interest rate and a constant payment schedule. |

JOIN | Text | - array - separator | JOIN(array, separator) | Joins the elements of one or more one-dimensional arrays using a given delimiter. |

KURT | Statistical | - number1 - [number2] | KURT(number1, [number2], ...) | Calculates the kurtosis of a set of values. |

LARGE | Statistical | - array - k | LARGE(array, k) | Returns the k'th largest value from an array of numeric values. |

LCM | Math | - number1 - number2 | LCM(number1, number2, ...) | Returns the least common multiple of two or more integers. |

LEFT | Text | - text - number | LEFT(text, number) | Returns a substring from the beginning of a text. |

LEN | Text | - text | LEN(text) | Returns the length of a text. |

LINEST | Array | - data_y - data_x | LINEST(data_y, data_x) | Calculate the line of best fit through a set of y- and x- values. |

LN | Math | - number | LN(number) | Returns the natural logarithm of a number. |

LOG | Math | - number - base | LOG(number, base) | Returns the logarithm of a number using a given base. |

LOG10 | Math | - number | LOG10(number) | Returns the base 10 logarithm of a number. |

LOGNORMDIST | Statistical | - x - mean - sd - cumulative | LOGNORMDIST(x, mean, sd, cumulative) | Calculates the Cumulative Log-Normal Distribution Function at a given value of x. |

LOGNORMINV | Statistical | - probability - mean - sd | LOGNORMINV(probability, mean, sd) | Calculates the inverse of the Cumulative Log-Normal Distribution Function of x, for a given probability. |

LOWER | Text | - text | LOWER(text) | Converts a specified string to lowercase. |

MAX | Statistical | - number1 - [number2] ... | MAX(number1, [number2], ...) | Returns the maximum value in a range of numbers. |

MAXA | Statistical | - value1 - [value2] ... | MAXA(value1, [value2], ...) | Returns the largest value in a list of arguments. |

MD5 | Math | - data - key - raw | MD5(data, key, raw) | Hashing function. |

MEDIAN | Statistical | - number1 - [number2] ... | MEDIAN(number1, [number2], ...) | Calculates the middle value in a range of numbers. |

MIN | Statistical | - number1 - [number2] ... | MIN(number1, [number2], ...) | Returns the minimum value in a range of numbers. |

MINA | Statistical | - value1 - [value2] ... | MINA(value1, [value2], ...) | Returns the minimum value in a list of arguments. |

MINUTE | Date | - date | MINUTE(date) | Returns the minute component of a specific time. |

MIRR | Financial | - values - finance_rate - reinvest_rate | MIRR(values, finance_rate, reinvest_rate) | Returns the modified internal rate of return (MIRR) for a series of cash flows. |

MOD | Math | - dividend - divisor | MOD(dividend, divisor) | Returns the result of the modulo operator. |

MODEMULT | Statistical | - range | MODEMULT(range) | Returns an array of the most frequently occurring numbers in a numeric data range. |

MODESNGL | Statistical | - number1 - [number2] | MODESNGL(number1, number2, ...) | Returns the most frequently occurring number in a numeric data set. |

MOMENT | Date | - date - format | MOMENT(date, format) | Returns date in given format. |

MOMENTADD | Date | - start_date - period - number | MOMENTADD(start_date, period, number) | Adds a number of periods (days, weeks, months, ) to a start date. Date is given as a text (in quotes). Example: =DATE(MOMENTADD('2018/12/10','weeks',5)) |

MOMENTDIFF | Date | - start_date - end_date - period | MOMENTDIFF(start_date, end_date, period) | Calculates difference between two dates. |

MOMENTFORMAT | Date | - date - format | MOMENTFORMAT(date, format) | Returns formatted date. |

MOMENTSUB | Date | - start_date - period - number | MOMENTSUB(start_date, period, number) | Subtracts a number of periods (days, weeks, months, ) from a start date. Date is given as a text (in quotes). |

MONTH | Date | - date | MONTH(date) | Returns the month from a given date. |

MROUND | Math | - number - multiple | MROUND(number, multiple) | Rounds a number to the nearest multiple of a given number. |

MULTINOMIAL | Math | - number1 - [number2] | MULTINOMIAL(number1, [number2], ...) | Returns the ratio of the factorial of a sum of values to the product of factorials of those values. |

NEGBINOMDIST | Statistical | - k - r - p - cumulative | NEGBINOMDIST(k, r, p, cumulative) | Calculates the negative binomial distribution for the given parameters. |

NETWORKDAYS | Date | - start_date - end_date - holidays | NETWORKDAYS(start_date, end_date, holidays) | Returns the number of net working days between two dates, optionally excluding holidays |

NETWORKDAYSINTL | Date | - start_date - end_date - weekend - holidays | NETWORKDAYSINTL(start_date, end_date, weekend, holidays) | Returns the number of net working days between two dates, excluding weekends and holidays. |

NOMINAL | Financial | - rate - periods | NOMINAL(rate, periods) | Returns the nominal interest rate for an effective interest rate and number of compounding periods per year. |

NORMDIST | Statistical | - x - mean - sd - cumulative | NORMDIST(x, mean, sd, cumulative) | Calculate the probability that variable x falls below or at a specified value. |

NORMINV | Statistical | - probability - mean - sd | NORMINV(probability, mean, sd) | Calculate the inverse of the normal cumulative distribution for the specified mean and standard deviation. |

NORMSDIST | Statistical | - z - cumulative | NORMSDIST(z, cumulative) | Calculates the Standard Normal Cumulative Distribution Function for a supplied value. |

NORMSINV | Statistical | - probability | NORMSINV(probability) | Calculates the inverse of the Standard Normal Cumulative Distribution Function for a supplied probability value. |

NOT | Logical | - logical | NOT(logical) | Returns the opposite of a logical value. |

NOW | Date | NOW() | Returns the current date and time. | |

NPER | Financial | - rate - payment - present - future - type | NPER(rate, payment, present, future, type) | Returns the number of periods for an annuity. |

NPV | Financial | NPV() | Returns the net present value of an annuity based on a series of periodic cash flows and a discount rate. | |

NUMBERS | Math | NUMBERS() | Returna array with numbers only from a given range. | |

NUMBERVALUE | Math | - text, - decimal_separator - group_separator | NUMBERVALUE(text, decimal_separator, group_separator) | Converts text to a number. Decimal and group separators are optional. |

NUMERAL | Math | - number - format | NUMERAL(number, format) | Returns number in a given format. |

OCT2BIN | Math | - number - places | OCT2BIN(number, places) | Converts an octal number to binary. |

OCT2DEC | Math | - number | OCT2DEC(number) | Converts an octal number to decimal. |

OCT2HEX | Math | - number - places | OCT2HEX(number, places) | Converts an octal number to hexadecimal. |

ODD | Math | - number | ODD(number) | Rounds a number up to the nearest odd integer. |

OR | Logical | - logical1 - [logical2] ... | OR(logical1, [logical2], ...) | Returns TRUE if any evaluated argument is TRUE. |

PDURATION | Financial | - rate - present - future | PDURATION(rate, present, future) | Returns the number of periods required by an annuity to reach a specified value. |

PEARSON | Statistical | - data_x - data_y | PEARSON(data_x, data_y) | Returns the Pearson product moment correlation coefficient. |

PERCENTILEEXC | Math | - array - k | PERCENTILEEXC(array, k) | Returns the k'th percentile for a given range and k. |

PERCENTILEINC | Math | - array - k | PERCENTILEINC(array, k) | Returns the k'th percentile for a given range and k. |

PERCENTRANKEXC | Math | - array - x - significance | PERCENTRANKEXC(array, x, significance) | Returns the relative position of a specified value within a given range. |

PERCENTRANKINC | Math | - array - x - significance | PERCENTRANKINC(array, x, significance) | Returns the relative position of a specified value within a given range. |

PERMUT | Statistical | - number - number_chosen | PERMUT(number, number_chosen) | Returns the number of permutations for a given number of objects. |

PERMUTATIONA | Statistical | - number - number_chosen | PERMUTATIONA(number, number_chosen) | Returns the number of permutations for a given number of objects. |

PHI | Statistical | - x | PHI(x) | Returns the value of the density function for a standard normal distribution. |

PI | Math | PI() | Returns the value of Pi constant to 15 decimal places. | |

PMT | Financial | - rate - periods - present - future - type | PMT(rate, periods, present, future, type) | Returns the periodic payment for a loan. |

POISSONDIST | Math | - x - mean - cumulative | POISSONDIST(x, mean, cumulative) | Calculates the Poisson Probability Mass Function. |

POWER | Math | - number - power | POWER(number, power) | Returns the number raised to a power. |

PPMT | Financial | - rate - period - periods - present - future - type | PPMT(rate, period, periods, present, future, type) | Calculates the payment on the principal of an investment. |

PROB | Statistical | - range - probability - lower - upper | PROB(range, probability, lower, upper) | Returns the probability that values in a range are between two limits. |

PRODUCT | Math | PRODUCT() | Multiplies its arguments. | |

PROPER | Text | - text | PROPER(text) | Capitalizes the first letter in each word of a text. |

PV | Financial | - rate - periods - payment - future - type | PV(rate, periods, payment, future, type) | Returns the present value of an investment. |

QUARTILEEXC | Math | - range - quart | QUARTILEEXC(range, quart) | Returns the quartile of a given range. |

QUARTILEINC | Math | - range - quart | QUARTILEINC(range, quart) | Returns the quartile of a given range. |

QUOTIENT | Math | - numerator - denominator | QUOTIENT(numerator, denominator) | Returns the integer portion of a division. |

RADIANS | Math | - number | RADIANS(number) | Converts an angle to radians. |

RAND | Math | RAND() | Returns a random number between 0 and 1. | |

RANDBETWEEN | Math | - bottom - top | RANDBETWEEN(bottom, top) | Returns a random number between the numbers. |

RANKAVG | Statistical | - number - range - order | RANKAVG(number, range, order) | Returns the statistical rank of a given value in a range. |

RANKEQ | Statistical | - number - range - order | RANKEQ(number, range, order) | Returns the statistical rank of a given value in a range. |

RATE | Financial | - periods - payment - present - future - type - guess | RATE(periods, payment, present, future, type, guess) | Returns the interest rate per period of an annuity. |

REGEXEXTRACT | Text | - text - regular_expression | REGEXEXTRACT(text, regular_expression) | Extracts matching substrings according to a regular expression. |

REGEXMATCH | Text | - text - regular_expression - full | REGEXMATCH(text, regular_expression, full) | Checks if the text matches a regular expression. |

REGEXREPLACE | Text | - text - regular_expression - replacement | REGEXREPLACE(text, regular_expression, replacement) | Replaces part of a text string with a different text string using regular expressions. |

REPLACE | Text | - text - position - length - new_text | REPLACE(text, position, length, new_text) | Replaces characters within text. |

REPT | Text | - text - number | REPT(text, number) | Repeats text a given number of times. |

RIGHT | Text | - text - number | RIGHT(text, number) | Returns a substring from the end of a specified string. |

ROMAN | Text | - number | ROMAN(number) | Converts an arabic numeral to roman (as text). |

ROUND | Math | - number - digits | ROUND(number, digits) | Rounds a number to a certain number of decimal place. |

ROUNDDOWN | Math | - number - digits | ROUNDDOWN(number, digits) | Rounds down a number to a certain number of decimal place. |

ROUNDUP | Math | - number - digits | ROUNDUP(number, digits) | Rounds up a number to a certain number of decimal place. |

SHEET | Lookup | - sheet_number - cell_range | SHEET(sheet_number, cell_range) | Returns the value or range from another sheet in the spreadsheet. |

RRI | Financial | - periods - present - future | RRI(periods, present, future) | Calculates an equivalent interest rate for the growth of an annuity. |

RSQ | Statistical | - data_x - data_y | RSQ(data_x, data_y) | Calculates the square of the Pearson product moment correlation coefficient. |

SEARCH | Text | - find_text - within_text - position | SEARCH(find_text, within_text, position) | Finds one text value within another (non case-sensitive) |

SEC | Math | - number | SEC(number) | Returns the secant of an angle ( radians). |

SECH | Math | - number | SECH(number) | Returns the hyperbolic secant of an angle. |

SECOND | Date | - date | SECOND(date) | Returns the second component of a given time. |

SERIESSUM | Math | - x - n - m - coefficients | SERIESSUM(x, n, m, coefficients) | Returns the sum of a power series based on the formula. |

SIGN | Math | - number | SIGN(number) | Returns the sign of a number. |

SIN | Math | - number | SIN(number) | Sine of a number. The number represents an angle in radians. |

SINH | Math | - number | SINH(number) | Returns the hyperbolic sine of a number (in radians). |

SKEW | Statistical | SKEW() | Returns the skewness of a distribution. | |

SKEWP | Statistical | SKEWP() | Returns the skewness of a distribution based on a population. | |

SLN | Financial | - cost - salvage - life | SLN(cost, salvage, life) | Returns the depreciation of an asset for one period. |

SLOPE | Statistical | - data_y - data_x | SLOPE(data_y, data_x) | Returns the slope of the linear regression line. |

SMALL | Statistical | - array - k | SMALL(array, k) | Returns the k-th smallest value in a range. |

SPLIT | Text | - text - separator | SPLIT(text, separator) | Returns an array of substrings divided by a separator. |

SQRT | Math | - number | SQRT(number) | Returns the positive square root of a positive number. |

SQRTPI | Math | - number | SQRTPI(number) | Returns the square root of a number multiplied by Pi constant. |

STANDARDIZE | Statistical | - x - mean - sd | STANDARDIZE(x, mean, sd) | Returns a normalized value. |

STDEVA | Statistical | STDEVA() | Calculates standard deviation based on a sample, including numbers, text, and logical values. | |

STDEVP | Statistical | STDEVP() | Calculates standard deviation based on the entire population. | |

STDEVPA | Statistical | STDEVPA() | Calculates standard deviation based on the entire population, including numbers, text, and logical values. | |

STDEVS | Statistical | STDEVS() | Calculates the sample standard deviation for the supplied values. | |

STEYX | Statistical | - data_y - data_x | STEYX(data_y, data_x) | Returns the standard error of the regression. |

STRING | Text | - value | STRING(value) | Returns a string from value. |

SUBSTITUTE | Text | - text - old_text - new_text - occurrence | SUBSTITUTE(text, old_text, new_text, occurrence) | Replaces existing text with new text in a string. |

SUBTOTAL | Math | - function_code | SUBTOTAL(function_code) | Returns an aggregate result for supplied values. |

SUM | Math | - number1 - [number2] ... | SUM(number1, [number2], ...) | Add the values in cells. Values can be given as a sequence (A1, B1, C1, ...) or range (A1:B10). |

SUMIF | Math | - range - criteria | SUMIF(range, criteria) | Returns a conditional sum of a range. |

SUMIFS | Math | - range - criteria1 - [criteria2] - | SUMIFS(range, criteria1, [criteria2], ...) | Returns the sum of a range, based on a multiple criteria. |

SUMPRODUCT | Array | - array1 - [array2] ... | SUMPRODUCT(array1, [array2], ...) | Multiplies the corresponding items in the arrays and returns the sum of the results. |

SUMSQ | Math | - number1 - [number2] ... | SUMSQ(number1, [number2], ...) | Returns the sum of the squares of a series of numbers. |

SUMX2MY2 | Array | - array_x - array_y | SUMX2MY2(array_x, array_y) | Calculates the sum of the differences of the squares of values in two arrays. |

SUMX2PY2 | Array | - array_x - array_y | SUMX2PY2(array_x, array_y) | Calculates the sum of the sums of the squares of corresponding items in the arrays. |

SUMXMY2 | Array | - array_x - array_y | SUMXMY2(array_x, array_y) | Calculates the sum of the squares of the differences between corresponding items in the arrays. |

SWITCH | Logical | SWITCH() | Compares one value against a list of values, and returns a result corresponding to the first match. | |

SYD | Financial | - cost - salvage - life - period | SYD(cost, salvage, life, period) | Calculates the depreciation of an asset for a specified period. |

T | Text | - value | T(value) | Returns string arguments as text. |

TAN | Math | - number | TAN(number) | Returns the tangent of a number (in radians) |

TANH | Math | - number | TANH(number) | Returns the hyperbolic tangent of a number. |

TBILLEQ | Financial | - settlement - maturity - discount | TBILLEQ(settlement, maturity, discount) | Calculates the bond-equivalent yield for Treasury Bill. |

TBILLPRICE | Financial | - settlement - maturity - discount | TBILLPRICE(settlement, maturity, discount) | Calculates the price of Treasury Bill based on discount rate. |

TBILLYIELD | Financial | - settlement - maturity - price | TBILLYIELD(settlement, maturity, price) | Calculates the yield of Treasury Bill. |

TDIST | Statistical | - x - df - cumulative | TDIST(x, df, cumulative) | Calculates the Student's T Distribution. |

TEXT | Text | - value - format | TEXT(value, format) | Converts a value into text based on a specified format. |

TIME | Date | - hour - minute - second | TIME(hour, minute, second) | Converts an hour, minute, and second into a time. |

TIMEVALUE | Date | - time_text | TIMEVALUE(time_text) | Converts a text representing a date, into a fraction of a 24-hour day. |

TINV | Statistical | - probability - df | TINV(probability, df) | Calculates the inverse of the two-tailed Student's T Distribution. |

TODAY | Date | TODAY() | Returns current date. | |

TRIM | Text | - text | TRIM(text) | Removes leading and trailing spaces from text. |

TRIMMEAN | Statistical | - range - percent | TRIMMEAN(range, percent) | Calculates mean of a range while excluding outliers. |

TRUE | Logical | TRUE() | Returns the logical value TRUE. | |

TRUNC | Math | - number - digits | TRUNC(number, digits) | Removes the fractional part of a number to a given number of significant digits. |

UNFLATTEN | Math | - array - numOfCols | UNFLATTEN(array, numOfCols) | Converts one dimensional array into multidimensional array based on the number of columns. |

UNICHAR | Text | - number | UNICHAR(number) | Returns the Unicode character based a given number. |

UNICODE | Text | - text | UNICODE(text) | Returns the code for the first character of a text. |

UNIQUE | Filter | - range | UNIQUE(range) | Returns unique rows in the provided range. |

UPPER | Text | - text | UPPER(text) | Convert text to all capital letters. |

VALIDBIN | Math | - number | VALIDBIN(number) | Checks if value is in binary format. |

VALUE | Text | - text | VALUE(text) | Converts text into a number. |

VARA | Statistical | - number1 - [number2] ... | VARA(value1, [value2],...) | Calculates the sample variance of a set of values. |

VARP | Statistical | - value1 - [value2] ... | VARP(value1, [value2],...) | Returns the variance of a set of values. |

VARPA | Statistical | - value1 - [value2] ... | VARPA(value1, value2,...) | Calculates the variance based on an entire population. |

VARS | Statistical | - value1 - [value2] ... | VARS(value1, [value2],...) | Calculates the variance of a sample of data. |

VLOOKUP | Search | - table - value - index - exactmatch | VLOOKUP(table, value, index, exactmatch) | Searches down and retrieve data from a specific column in table. |

WEEKDAY | Date | - date - type | WEEKDAY(date, type) | Returns a number between 1-7 representing the day of week. |

WEEKNUM | Date | - date - type | WEEKNUM(date, type) | Returns a week number that corresponds to the week of year. |

WEIBULLDIST | Statistical | - x - alpha - beta - cumulative | WEIBULLDIST(x, alpha, beta, cumulative) | Returns the value of the Weibull distribution function. |

WORKDAY | Date | - start_date - days - holidays | WORKDAY(start_date, days, holidays) | Returns the nearest working day in the future or past. |

WORKDAYINTL | Date | - start_date - days - weekend - holidays | WORKDAYINTL(start_date, days, weekend, holidays) | Returns the nearest working day in the future or past, based on an offset value. |

XIRR | Financial | - values - dates - guess | XIRR(values, dates, guess) | Returns the internal rate of return (IRR) for a series of cash flows that occur at irregular intervals. |

XNPV | Financial | - rate - values - dates | XNPV(rate, values, dates) | Calculates the net present value (NPV) of an investment using a discount rate and a series of cash flows that occur at irregular intervals. |

XOR | Logical | - logical1 - [logical2] ... | XOR(logical1, [logical2], ...) | Logical exclusive OR of all arguments. |

YEAR | Date | - date | YEAR(date) | Returns the year from a given date. |

YEARFRAC | Date | - start_date - end_date - basis | YEARFRAC(start_date, end_date, basis) | Returns a decimal value that represents fractional years between two dates. |

ZTEST | Statistical | - range - x - sigma | ZTEST(range, x, sigma) | Returns the probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |