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