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. |