List of available functions (ver. 0.9.0)
| Function | Type | Arguments | Syntax | Description |
|---|---|---|---|---|
| ABS | Math | - number | ABS(number) | Returns the absolute value of a number. |
| ACCRINT | Financial | - issue - 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. |
| ACOTH | Math | - number | ACOTH(number) | Returns the inverse hyperbolic cotangent of a number. |
| 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). |
| 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. |
| 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 | Math | - trials - probability - successes - successes2 | BINOMDISTRANGE(trials, probability, successes, successes2) | Returns the Binomial Distribution probability for a number. |
| BINOMINV | Math | - 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 a 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 | Math | - 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. |
| 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 | Math | - 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 Student’s t-distribution. |
| CONVERT | Engineering | - 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 | COUNTUNIQUE() | Counts how many unique values exist in a range that contains duplicate values. | |
| COVARIANCEP | Math | - 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. |
| DATEVALUE | Date | - date_text | DATEVALUE(date_text) | Converts a date represented as text into a date. |
| 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. |
| 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. |
| 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. |
| 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 | Engineering | - 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. |
| EVEN | Math | - 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. |
| EXPONDIST | Statistical | - x - lambda - cumulative | EXPONDIST(x, lambda, cumulative) | Returns the value of the exponential distribution for a given value. |
| 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. |
| 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. |
| 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. |
| 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. |
| IMAGE | Graphical | - src - mode - width - height - title | IMAGE(src, mode, width, height, title) | Inserts an image from a given url into a cell. |
| INT | Math | - number | INT(number) | Rounds a number down to the nearest integer. |
| IPMT | Math | - 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, |
| ISEVEN | Financial | - number | ISEVEN(number) | Checks whether the provided number is even and returns TRUE or FALSE. |
| ISODD | Math | - number | ISODD(number) | Checks whether the provided number is odd and returns TRUE or FALSE. |
| ISPMT | Math | - 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. |
| 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. |
| 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. |
| 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. |
| MOD | Math | - dividend - divisor | MOD(dividend, divisor) | Returns the result of the modulo operator. |
| NOT | Logical | - logical | NOT(logical) | Returns the opposite of a logical value. |
| 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. |
| 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. |
| POWER | Math | - number - power | POWER(number, power) | Returns the number raised to a power. |
| PV | Financial | - rate - periods - payment - future - type | PV(rate, periods, payment, future, type) | Returns the present value of an investment. |
| RATE | Financial | - periods - payment - present - future - type - guess | RATE(periods, payment, present, future, type, guess) | Returns the interest rate per period of an annuity. |
| 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 | TotalSheets | - sheet_number - cell_range | SHEET(sheet_number, cell_range) | Returns the value or range from another sheet in the spreadsheet. |
| 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). |
| 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. |
| STRING | Text | - value | STRING(value) | Returns string from a value. |
| 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 | Math | - 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 | Math | - array_x - array_y | SUMX2MY2(array_x, array_y) | Calculates the sum of the differences of the squares of values in two arrays. |
| SUMX2PY2 | Math | - 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 | Math | - array_x - array_y | SUMXMY2(array_x, array_y) | Calculates the sum of the squares of the differences between corresponding items in the arrays. |
| 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. |
| TINV | Statistical | - probability - df | TINV(probability, df) | Calculates the inverse of the two-tailed Student's T Distribution. |
| 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. |
| UPPER | Text | - text | UPPER(text) | Convert text to all capital letters. |
| VLOOKUP | Search | - table - cols - value - index - exactmatch | VLOOKUP(table, cols, value, index, exactmatch) | Searches down and retrieve data from a specific column in table. |
| XOR | Logical | - logical1 - [logical2] ... | XOR(logical1, [logical2], ...) | Logical exclusive OR of all arguments. |