Functions

You are here:

List of available functions (ver. 0.9.0)

FunctionTypeArgumentsSyntaxDescription
ABSMath- numberABS(number)Returns the absolute value of a number.
ACCRINTFinancial- 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.
ACCRINTMFinancial- issue
- settlement
- rate
- par
- basis
ACCRINTM(issue, settlement, rate, par, basis)Calculates the accrued interest for a security that pays interest on maturity.
ACOSMath- numberACOS(number)Returns the arccosine of a number (in radians).
ACOSHMath- numberACOSH(number)Returns the inverse hyperbolic cosine of a number.
ACOTHMath- numberACOTH(number)Returns the inverse hyperbolic cotangent of a number.
AMORDEGRCFinancial- 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.
AMORLINCFinancial- 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.
ANDLogical- logical1
- [logical2]
...
AND(logical1, [logical2], ...)Check if all conditions are TRUE.
ARABICText- textARABIC(text)Converts a Roman number to Arabic.
ARGSCONCATText- argsARGSCONCAT(args)Joins 2 or more strings together.
ASINMath- numberASIN(number)Returns the inverse sine of a number (in radians).
ASINHMath- numberASINH(number)Returns the the nverse hyperbolic sine of a number.
ATANMath- numberATAN(number)Returns the inverse tangent of a number (in radians).
ATAN2Math- number_x
- number_y
ATAN2(number_x, number_y)Returns the arc tangent of the two numbers (in radians).
ATANHMath- numberATANH(number)Returns the inverse hyperbolic tangent of a number (in radians).
AVEDEVStatistical- number1
- [number2]
AVEDEV(number1, [number2], ...)Average of the absolute deviations of data points from their mean.
AVERAGEStatistical- number1
- [number2]
AVERAGE(number1, [number2], ...)Returns the average of the arguments.
AVERAGEAStatistical- number1
- [number2]
AVERAGEA(number1, [number2], ...)Returns the average value in a range of numbers.
AVERAGEIFStatistical- range
- criteria
- average_range
AVERAGEIF(range, criteria, average_range)Returns the average of a range depending on criteria.
BASEMath- number
- radix
- min_length
BASE(number, radix, min_length)Converts a number into a text representation with the given base.
BESSELIMath- x
- n
BESSELI(x, n)Returns the modified Bessel function.
BESSELJMath- x
- n
BESSELJ(x, n)Returns the Bessel function for a specified order and value of x.
BESSELKMath- x
- n
BESSELK(x, n)Returns the modified Bessel function.
BESSELYMath- x
- n
BESSELY(x, n)Returns the Bessel function, also known as the Weber function or the Neumann function.
BETADISTStatistical- x
- alpha
- beta
- cumulative
- A
- B
BETADIST(x, alpha, beta, cumulative, A, B)Returns the cumulative beta probability density function.
BETAINVStatistical- probability
- alpha
- beta
- A
- B
BETAINV(probability, alpha, beta, A, B)Returns the inverse of the cumulative beta probability density function.
BIN2DECEngineering- numberBIN2DEC(number)Converts a binary number to a decimal number.
BIN2HEXEngineering- number
- places
BIN2HEX(number, places)Converts a binary number to a hexadecimal format.
BIN2OCTEngineering- number
- places
BIN2OCT(number, places)Converts a binary number to a octal format
BINOMDISTStatistical- successes
- trials
- probability
- cumulative
BINOMDIST(successes, trials, probability, cumulative)Returns the individual term binomial distribution probability.
BINOMDISTRANGEMath- trials
- probability
- successes
- successes2
BINOMDISTRANGE(trials, probability, successes, successes2)Returns the Binomial Distribution probability for a number.
BINOMINVMath- trials
- probability
- alpha
BINOMINV(trials, probability, alpha)Returns the inverse of the Cumulative Binomial Distribution.
BITANDEngineering- number1
- number2
BITAND(number1, number2)Bitwise boolean AND of two numbers.
BITLSHIFTEngineering- number
- shift
BITLSHIFT(number, shift)Shifts a number by the specified number of bits to the left.
BITOREngineering- number1
- number2
BITOR(number1, number2)Bitwise boolean OR of two numbers.
BITRSHIFTEngineering- number
- shift
BITRSHIFT(number, shift)Shifts a number by the specified number of bits to the right.
BITXOREngineering- number1
- number2
BITXOR(number1, number2)Bitwise XOR of two numbers.
CHARTGraphical- xvalues
- yvalues
- library
- type
- options
CHART(xvalues, yvalues, library, type, options)Shows a chart based on the chosen library.
CHART_SPARKLINESGraphical- xvalues
- yvalues
- type
- options
CHART_SPARKLINES(xvalues, yvalues, type, options)Shows the jQuery.Sparklines chart.
CHART_RGRAPHGraphical- xvalues
- yvalues
- type
- options
CHART_RGRAPH(xvalues, yvalues, type, options)Shows the RGraph chart.
CEILINGMath- number
- significance
- mode
CEILING(number, significance, mode)Rounds the number up to the nearest integer of specified significance.
CEILINGMATHMath- number
- significance
- mode
CEILINGMATH(number, significance, mode)Rounds a number up to a specified multiple.
CEILINGPRECISEMath- number
- significance
- mode
CEILINGPRECISE(number, significance, mode)Rounds a number up to a given multiple.
CHARText- numberCHAR(number)Returns the character based on the corresponding numeric value.
CHISQDISTMath- x
- k
- cumulative
CHISQDIST(x, k, cumulative)Calculates the right-tailed probability of a chi-square distribution.
CHISQINVStatistical- probability
- k
CHISQINV(probability, k)Calculate the inverse of the left-tailed probability of the chi-square distribution.
CODEText- textCODE(text)Returns the numeric code for the first character of a supplied string.
COMBINMath- number
- number_chosen
COMBIN(number, number_chosen)Returns the number of combinations for a specified number of items.
COMBINAMath- number
- number_chosen
COMBINA(number, number_chosen)Returns the number of combinations for a specified number of items and includes repetitions.
COMPLEXEngineering- real
- imaginary
- suffix
COMPLEX(real, imaginary, suffix)Converts coefficients into a complex number.
CONCATENATEText- text1
- text2
CONCATENATE(text1, text2, ...)Joins together two or more text strings.
CONFIDENCENORMMath- alpha
- sd
- n
CONFIDENCENORM(alpha, sd, n)Returns the confidence interval for a population mean, for a supplied probablity and sample size.
CONFIDENCETStatistical- 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.
CONVERTEngineering- number
- from_unit
- to_unit
CONVERT(number, from_unit, to_unit)Converts a numeric value to a different unit of measure.
CORRELStatistical- number1
- [number2]
CORREL(number1, [number2], ...)Calculates r, the Pearson product-moment correlation coefficient of the numbers.
COSMath- numberCOS(number)Cosine of a number.?The number represents an angle in radians.
COSHMath- numberCOSH(number)Returns the hyperbolic cosine of a number.
COTMath- numberCOT(number)Returns the cotangent of a number (in radians).
COTHMath- numberCOTH(number)Returns the hyperbolic cotangent of a number.
COUNTStatistical- number1
- [number2]
COUNT(number1, [number2], ...)Counts the number of cells that contain numeric values.
COUNTAStatistical- number1
- [number2]
COUNTA(number1, [number2], ...)Counts the number of cells in a range of values.
COUNTBLANKMath- rangeCOUNTBLANK(range)Counts the empty cells in a range.
COUNTIFMath- range
- criteria
COUNTIF(range, criteria)Counts cells that meet criteria.
COUNTIFSMath- range
- criteria1
- [criteria2]
- …
COUNTIFS(range, criteria1, [criteria2], ...)Counts the number of cells in a range, that meets a single or multiple criteria.
COUNTINMath- range
- value
COUNTIN(range, value)Counts the number of cells in a range that contain numbers.
COUNTUNIQUEMathCOUNTUNIQUE()Counts how many unique values exist in a range that contains duplicate values.
COVARIANCEPMath- array1
- array2
COVARIANCEP(array1, array2)Calculates the population covariance of two arrays.
COVARIANCESMath- array1
- array2
COVARIANCES(array1, array2)Calculate the sample covariance for two arrays.
CSCMath- numberCSC(number)Returns the cosecant of a number (in radians).
CSCHMath- numberCSCH(number)Returns the hyperbolic cosecant of a number (in radians).
CUMIPMTFinancial- 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.
CUMPRINCFinancial- rate
- periods
- value
- start
- end
- type
CUMPRINC(rate, periods, value, start, end, type)Calculates the cumulative principal paid on a loan or an investment.
DATEDate- year
- month
- day
DATE(year, month, day)Converts a provided year, month, and day into a date.
DATEVALUEDate- date_textDATEVALUE(date_text)Converts a date represented as text into a date.
DAYDate- dateDAY(date)Returns the day of the month as a number between 1 to 31.
DAYSDate- end_date
- start_date
DAYS(end_date, start_date)Returns the number of days between two dates.
DAYS360Date- 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.
DBFinancial- 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.
DDBFinancial- 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.
DEC2BINEngineering- number
- places
DEC2BIN(number, places)Converts a decimal number to binary format.
DEC2HEXEngineering- number
- places
DEC2HEX(number, places)Converts a decimal number to hexadecimal format.
DEC2OCTEngineering- number
- places
DEC2OCT(number, places)Converts a decimal number to octal format.
DECIMALMath- number
- radix
DECIMAL(number, radix)Converts an alpha-numeric number into its decimal equivalent.
DEGREESMath- numberDEGREES(number)Converts an angle value in radians to degrees.
DELTAEngineering- number1
- number2
DELTA(number1, number2)Compares two numeric values and returns 1 if they're equal.
DEVSQStatistical- rangeDEVSQ(range)Calculates the sum of the squared deviations from the sample mean.
DOLLARText- number
- decimals
DOLLAR(number, decimals)Formats a number into text, using a currency format.
DOLLARDEFinancial- dollar
- fraction
DOLLARDE(dollar, fraction)Converts a dollar value in fractional notation into a decimal notation.
DOLLARFRFinancial- dollar
- fraction
DOLLARFR(dollar, fraction)Converts a dollar value in decimal notation into a fractional notation.
EMathE()Returns the value of E constant to 15 decimal places.
EDATEDate- start_date
- months
EDATE(start_date, months)Adds a number of months to a date and returns the result as a date.
EFFECTFinancial- rate
- periods
EFFECT(rate, periods)Returns the effective annual interest rate, from the nominal annual interest rate.
EOMONTHDate- start_date
- months
EOMONTH(start_date, months)Calculates the last day of the month after adding a number of months to a date.
ERFEngineering- lower_bound
- upper_bound
ERF(lower_bound, upper_bound)Returns the integral of the Gauss error function over an interval of values.
ERFCMath- xERFC(x)Calculates the Complementary Error Function integrated between a supplied lower limit and infinity.
EVENMath- numberEVEN(number)Rounds a number up to the nearest even integer.
EXACTText- text1
- text2
EXACT(text1, text2)Compares two strings and checks whether they are identical. Returns TRUE or FALSE.
EXPONDISTStatistical- x
- lambda
- cumulative
EXPONDIST(x, lambda, cumulative)Returns the value of the exponential distribution for a given value.
FALSELogicalFALSE()Returns the logical value FALSE.
FDISTStatistical- 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.
FINVStatistical- probability
- d1
- d2
FINV(probability, d1, d2)Calculates the inverse of the right-tailed F distribution for a given probability.
FISHERStatistical- xFISHER(x)Calculates the Fisher Transformation for a given value.
FISHERINVStatistical- yFISHERINV(y)Calculates the inverse Fisher Transformation for a given value.
FVFinancial- rate
- periods
- payment
- value
- type
FV(rate, periods, payment, value, type)Returns the future value of an investment based on a constant interest rate.
IFLogical- 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.
IMAGEGraphical- src
- mode
- width
- height
- title
IMAGE(src, mode, width, height, title)Inserts an image from a given url into a cell.
INTMath- numberINT(number)Rounds a number down to the nearest integer.
IPMTMath- 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,
ISEVENFinancial- numberISEVEN(number)Checks whether the provided number is even and returns TRUE or FALSE.
ISODDMath- numberISODD(number)Checks whether the provided number is odd and returns TRUE or FALSE.
ISPMTMath- 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.
LNMath- numberLN(number)Returns the natural logarithm of a number.
LOGMath- number
- base
LOG(number, base)Returns the logarithm of a number using a given base.
LOG10Math- numberLOG10(number)Returns the base 10 logarithm of a number.
LOWERText- textLOWER(text)Converts a specified string to lowercase.
MAXStatistical- number1
- [number2]
...
MAX(number1, [number2], ...)Returns the maximum value in a range of numbers.
MAXAStatistical- value1
- [value2]
...
MAXA(value1, [value2], ...)Returns the largest value in a list of arguments.
MEDIANStatistical- number1
- [number2]
...
MEDIAN(number1, [number2], ...)Calculates the middle value in a range of numbers.
MINStatistical- number1
- [number2]
...
MIN(number1, [number2], ...)Returns the minimum value in a range of numbers.
MINAStatistical- value1
- [value2]
...
MINA(value1, [value2], ...)Returns the minimum value in a list of arguments.
MODMath- dividend
- divisor
MOD(dividend, divisor)Returns the result of the modulo operator.
NOTLogical- logicalNOT(logical)Returns the opposite of a logical value.
ODDMath- numberODD(number)Rounds a number up to the nearest odd integer.
ORLogical- logical1
- [logical2]
...
OR(logical1, [logical2], ...)Returns TRUE if any evaluated argument is TRUE.
PIMathPI()Returns the value of Pi constant to 15 decimal places.
PMTFinancial- rate
- periods
- present
- future
- type
PMT(rate, periods, present, future, type)Returns the periodic payment for a loan.
POWERMath- number
- power
POWER(number, power)Returns the number raised to a power.
PVFinancial- rate
- periods
- payment
- future
- type
PV(rate, periods, payment, future, type)Returns the present value of an investment.
RATEFinancial- periods
- payment
- present
- future
- type
- guess
RATE(periods, payment, present, future, type, guess)Returns the interest rate per period of an annuity.
ROUNDMath- number
- digits
ROUND(number, digits)Rounds a number to a certain number of decimal place.
ROUNDDOWNMath- number
- digits
ROUNDDOWN(number, digits)Rounds down a number to a certain number of decimal place.
ROUNDUPMath- number
- digits
ROUNDUP(number, digits)Rounds up a number to a certain number of decimal place.
SHEETTotalSheets- sheet_number
- cell_range
SHEET(sheet_number, cell_range)Returns the value or range from another sheet in the spreadsheet.
SINMath- numberSIN(number)Sine of?a number.?The number represents an angle in radians.
SINHMath- numberSINH(number)Returns the hyperbolic sine of a number (in radians).
SPLITText- text
- separator
SPLIT(text, separator)Returns an array of substrings divided by a separator.
SQRTMath- numberSQRT(number)Returns the positive square root of a positive number.
SQRTPIMath- numberSQRTPI(number)Returns the square root of a number multiplied by Pi constant.
STRINGText- valueSTRING(value)Returns string from a value.
SUMMath- number1
- [number2]
...
SUM(number1, [number2], ...)Add the values in cells. Values can be given as a sequence (A1, B1, C1, ...) or range (A1:B10).
SUMIFMath- range
- criteria
SUMIF(range, criteria)Returns a conditional sum of a range.
SUMIFSMath- range
- criteria1
- [criteria2]
- …
SUMIFS(range, criteria1, [criteria2], ...)Returns the sum of a range, based on a multiple criteria.
SUMPRODUCTMath- array1
- [array2]
...
SUMPRODUCT(array1, [array2], ...)Multiplies the corresponding items in the arrays and returns the sum of the results.
SUMSQMath- number1
- [number2]
...
SUMSQ(number1, [number2], ...)Returns the sum of the squares of a series of numbers.
SUMX2MY2Math- array_x
- array_y
SUMX2MY2(array_x, array_y)Calculates the sum of the differences of the squares of values in two arrays.
SUMX2PY2Math- array_x
- array_y
SUMX2PY2(array_x, array_y)Calculates the sum of the sums of the squares of corresponding items in the arrays.
SUMXMY2Math- array_x
- array_y
SUMXMY2(array_x, array_y)Calculates the sum of the squares of the differences between corresponding items in the arrays.
TANMath- numberTAN(number)Returns the tangent of a number (in radians)
TANHMath- numberTANH(number)Returns the hyperbolic tangent of a number.
TINVStatistical- probability
- df
TINV(probability, df)Calculates the inverse of the two-tailed Student's T Distribution.
TRUELogicalTRUE()Returns the logical value TRUE.
TRUNCMath- number
- digits
TRUNC(number, digits)Removes the fractional part of a number to a given number of significant digits.
UPPERText- textUPPER(text)Convert text to all capital letters.
VLOOKUPSearch- table
- cols
- value
- index
- exactmatch
VLOOKUP(table, cols, value, index, exactmatch)Searches down and retrieve data from a specific column in table.
XORLogical- logical1
- [logical2]
...
XOR(logical1, [logical2], ...)Logical exclusive OR of all arguments.