You are here:

List of available functions (ver. 0.9.4)

FunctionTypeArgumentsSyntaxDescription
ABSMath- numberABS(number)Returns the absolute value of a number.
ACCRINTFinancial- 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.
ACOTMath- numberACOT(number)Returns the inverse hyperbolic cotangent of a value (in radians).
ACOTHMath- numberACOTH(number)Returns the inverse hyperbolic cotangent of a number.
AGGREGATEMath- function_code
- arg1
- arg2
...
AGGREGATE(function_code, arg1, arg2, ...)Returns a aggregate calculation of selected functions (function code 1-19)
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).
ASINMath- numberASIN(number)Returns the inverse sine of a value (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.
AVERAGEIFSStatisticalAVERAGEIFS()Returns the average of a range depending on multiple 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.
BINOMDISTRANGEStatistical- 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.
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 the 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.
CHISQDISTStatistical- 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.
CLEANText- textCLEAN(text)Removes non-printable ASCII characters from string.
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.
CONFIDENCENORM- 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.
CONVERTParser- 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.
COUNTUNIQUEMath- rangeCOUNTUNIQUE(range)Counts how many unique values exist in a range that contains duplicate values.
COVARIANCEPStatistical- 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.
DATEDIFDate- start_date
- end_date
- interval
DATEDIF(start_date, end_date, interval)Returns the difference between two date values in years, months, or days.
DATEVALUEDate- date_textDATEVALUE(date_text)Converts a date represented as text into a date.
DAVERAGEDatabase- database
- field
- criteria
DAVERAGE(database, field, criteria)Returns the average in a given field for records that match criteria.
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.
DCOUNTDatabase- database
- field
- criteria
DCOUNT(database, field, criteria)Counts matching values in a database, array or a range using criteria and an optional field.
DCOUNTADatabase- database
- field
- criteria
DCOUNTA(database, field, criteria)See DCOUNT.
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.
DGETDatabase- database
- field
- criteria
DGET(database, field, criteria)Returns a single value in a given field from a record that matches criteria.
DMAXDatabase- database
- field
- criteria
DMAX(database, field, criteria)Returns the maximum value in a field, from a set of records that match criteria.
DMINDatabase- database
- field
- criteria
DMIN(database, field, criteria)Returns the minimum value in a field, from a set of records that match criteria.
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.
DPRODUCTDatabase- database
- field
- criteria
DPRODUCT(database, field, criteria)Returns the product of values from a set of records that match criteria.
DSTDEVDatabase- database
- field
- criteria
DSTDEV(database, field, criteria)Returns the standard deviation of pupulation sample extracted from records that match criteria.
DSTDEVPDatabase- database
- field
- criteria
DSTDEVP(database, field, criteria)Returns the standard deviation for an entire population from records that match criteria.
DSUMDatabase- database
- field
- criteria
DSUM(database, field, criteria)Returns the sum of values from a database, array or range that match criteria.
DVARDatabase- database
- field
- criteria
DVAR(database, field, criteria)Returns the variance of a sample extracted from records that match criteria.
DVARPDatabase- database
- field
- criteria
DVARP(database, field, criteria)Returns the variance of an entire population extracted from records that match criteria.
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.
ERFMath- 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.
ERFCPRECISEMath- xERFCPRECISE(x)See ERFC.
ERFPRECISEMath- xERFPRECISE(x)Returns the error function.
EVENText- 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.
EXPMathEXP()Returns Euler's number, e (~2.718) raised to a power.
EXPONDISTStatistical- x
- lambda
- cumulative
EXPONDIST(x, lambda, cumulative)Returns the value of the exponential distribution for a given value.
FACTMath- numberFACT(number)Returns the factorial of a number.
FACTDOUBLEMath- numberFACTDOUBLE(number)Returns the double factorial of a number.
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.
FINDText- find_text
- within_text
- position
FIND(find_text, within_text, position)Returns the position of text inside another one.
FINDFIELDDatabase- database
- title,
FINDFIELD(database, title)Returns index of column inside database, array or range.
FINDRESULTINDEXDatabase- database
- criteria
FINDRESULTINDEX(database, criteria)Returns indexes of columns inside database, array or range based on criteria.
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.
FIXEDText- number
- decimals
- no_commas
FIXED(number, decimals, no_commas)Formats a number with a fixed number of decimal places.
FLATTENMath- arrayFLATTEN(array)Flatten multi-dimensional array to one dimension.
FLOORMath- number
- significance
- mode
FLOOR(number, significance, mode)Rounds a given number down to the nearest specified multiple.
FLOORMATHMath- number
- significance
- mode
FLOORMATH(number, significance, mode)Rounds a number down to a specified multiple.
FLOORPRECISEMath- number
- significance
FLOORPRECISE(number, significance)See FLOORMATH.
FORECASTStatistical- x
- data_y
- data_x
FORECAST(x, data_y, data_x)Calculates a future value of x based on linear regression of dataset.
FREQUENCYArray- data
- bins
FREQUENCY(data, bins)Returns a frequency distribution.
FROMNOWDate- timestamp
- nosuffix
FROMNOW(timestamp, nosuffix)Returns time that has passed since a given date.
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.
FVSCHEDULEFinancial- principal
- schedule
FVSCHEDULE(principal, schedule)Calculates the future value of an investment with a variable interest rate.
GAMMAMath- shape
- scale
GAMMA(shape, scale)Returns the value of the Gamma distribution with the parameters shape (k) and scale (theta).
GAMMALNMath- xGAMMALN(x)Returns the Log-Gamma function evaluated at x.
GAUSSStatistical- zGAUSS(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.
GCDMath- number1
- [number2]
...
GCD(number1, number2, ...)Returns the greatest common divisor of two or more integers.
GEOMEANStatistical- rangeGEOMEAN(range)Returns the geometric mean for a set of numeric values.
GESTEPEngineering- number
- step
GESTEP(number, step)Returns TRUE if a supplied number is greater than a supplied step size or FALSE otherwise.
GETJSONFile- fileGETJSON(file)Returns the entire file in JSON format.
GROWTHMath- 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.
HARMEANStatistical- rangeHARMEAN(range)Calculates the harmonic mean of a range.
HEX2BINEngineering- number
- places
HEX2BIN(number, places)Converts a hexadecimal number to binary format.
HEX2DECEngineering- numberHEX2DEC(number)Converts a hexadecimal number to decimal format.
HEX2OCTEngineering- number
- places
HEX2OCT(number, places)Converts a hexadecimal number to octal format.
HOURDate- dateHOUR(date)Returns hour from a given date.
HTML2TEXTText- valueHTML2TEXT(value)Strips html from text or numbers.
HYPGEOMDISTStatistical- 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.
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.
IFERRORLogical- value
- valueIfError
IFERROR(value, valueIfError)Returns a custom result when a formula generates an error.
IFNALogical- 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.
IMABSEngineering- inumberIMABS(inumber)Returns the absolute value of a complex number.
IMAGEGraphical- src
- mode
- width
- height
- title
IMAGE(src, mode, width, height, title)Inserts an image from a given url into a cell.
IMAGINARYMath- inumberIMAGINARY(inumber)Returns the imaginary coefficient of a supplied complex number.
IMARGUMENTMath- inumberIMARGUMENT(inumber)Returns an angle expressed in radians of a complex number.
IMCONJUGATEMath- inumberIMCONJUGATE(inumber)Returns the complex conjugate of a complex number.
IMCOSMath- inumberIMCOS(inumber)Returns the cosine of a complex number.
IMCOSHMath- inumberIMCOSH(inumber)Returns the hyperbolic cosine of a complex number.
IMCOTMath- inumberIMCOT(inumber)Returns the cotangent of a complex number.
IMCSCMath- inumberIMCSC(inumber)Returns the cosecant of a complex number.
IMCSCHMath- inumberIMCSCH(inumber)Returns the hyperbolic cosecant of a complex number.
IMDIVMath- inumber1
- inumber2
IMDIV(inumber1, inumber2)Returns division of two complex numbers.
IMEXPMath- inumberIMEXP(inumber)Returns the exponential of a complex number.
IMLNMath- inumberIMLN(inumber)Returns the natural logarithm of a complex number.
IMLOG10Math- inumberIMLOG10(inumber)Returns the base 10 logarithm of a complex number.
IMLOG2Math- inumberIMLOG2(inumber)Returns the base 2 logarithm of a complex number.
IMPOWERMath- inumber1
- number
IMPOWER(inumber, number)Returns a complex number raised to a power.
IMPRODUCTEngineering- number1
- [number2]
...
IMPRODUCT(number1, [number2], ...)Calculates the product of two or more complex numbers.
IMREALMath- inumberIMREAL(inumber)Returns the real coefficient of a complex number
IMSECMath- inumberIMSEC(inumber)Returns the secant of a complex number.
IMSECHMath- inumberIMSECH(inumber)Returns the hyperbolic secant of a complex number.
IMSINMath- inumberIMSIN(inumber)Returns the sine of a complex number.
IMSINHMath- inumberIMSINH(inumber)Returns the hyperbolic sine of a complex number.
IMSQRTMath- inumberIMSQRT(inumber)Returns the square root of a complex number.
IMSUBMath- inumber1
- inumber2
IMSUB(inumber1, inumber2)Calculates the difference between two complex numbers.
IMSUMMathIMSUM()Calculates the sum of two or more complex numbers.
IMTANMath- inumberIMTAN(inumber)Returns tangent of a complex number.
INTMath- numberINT(number)Rounds a number down to the nearest integer.
INTERCEPTStatistical- 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.
INTERVALMath- secondINTERVAL(second)Converts interval given in seconds into years, months, days, hours, minutes and seconds.
IPMTFinancial- 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,
IRRFinancial- values
- guess
IRR(values, guess)Returns the internal rate of return (IRR) for a series of cash flows that occur at regular intervals.
ISERRInfo- valueISERR(value)Checks whether a value is an error other than #N/A.
ISERRORInfo- valueISERROR(value)Checks whether a value is an error.
ISEVENMath- numberISEVEN(number)Checks whether the provided number is even and returns TRUE or FALSE.
ISNUMBERLogical- numberISNUMBER(number)Checks whether a value is a number.
ISOCEILINGMath- number
- significance
- mode
ISOCEILING(number, significance, mode)Rounds a number up, to the nearest multiple of significance.
ISODDMath- numberISODD(number)Checks whether the provided number is odd and returns TRUE or FALSE.
ISOWEEKNUMDate- dateISOWEEKNUM(date)Returns a week number that follows ISO standards.
ISPMTFinancial- 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.
JOINText- array
- separator
JOIN(array, separator)Joins the elements of one or more one-dimensional arrays using a given delimiter.
KURTStatistical- number1
- [number2]
…
KURT(number1, [number2], ...)Calculates the kurtosis of a set of values.
LARGEStatistical- array
- k
LARGE(array, k)Returns the k'th largest value from an array of numeric values.
LCMMath- number1
- number2
…
LCM(number1, number2, ...)Returns the least common multiple of two or more integers.
LEFTText- text
- number
LEFT(text, number)Returns a substring from the beginning of a text.
LENText- textLEN(text)Returns the length of a text.
LINESTArray- data_y
- data_x
LINEST(data_y, data_x)Calculate the line of best fit through a set of y- and x- values.
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.
LOGNORMDISTStatistical- x
- mean
- sd
- cumulative
LOGNORMDIST(x, mean, sd, cumulative)Calculates the Cumulative Log-Normal Distribution Function at a given value of x.
LOGNORMINVStatistical- probability
- mean
- sd
LOGNORMINV(probability, mean, sd)Calculates the inverse of the Cumulative Log-Normal Distribution Function of x, for a given probability.
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.
MD5Math- data
- key
- raw
MD5(data, key, raw)Hashing function.
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.
MINUTEDate- dateMINUTE(date)Returns the minute component of a specific time.
MIRRFinancial- 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.
MODMath- dividend
- divisor
MOD(dividend, divisor)Returns the result of the modulo operator.
MODEMULTStatistical- rangeMODEMULT(range)Returns an array of the most frequently occurring numbers in a numeric data range.
MODESNGLStatistical- number1
- [number2]
…
MODESNGL(number1, number2, ...)Returns the most frequently occurring number in a numeric data set.
MOMENTDate- date
- format
MOMENT(date, format)Returns date in given format.
MOMENTADDDate- 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))
MOMENTDIFFDate- start_date
- end_date
- period
MOMENTDIFF(start_date, end_date, period)Calculates difference between two dates.
MOMENTFORMATDate- date
- format
MOMENTFORMAT(date, format)Returns formatted date.
MOMENTSUBDate- 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).
MONTHDate- dateMONTH(date)Returns the month from a given date.
MROUNDMath- number
- multiple
MROUND(number, multiple)Rounds a number to the nearest multiple of a given number.
MULTINOMIALMath- number1
- [number2]
…
MULTINOMIAL(number1, [number2], ...)Returns the ratio of the factorial of a sum of values to the product of factorials of those values.
NEGBINOMDISTStatistical- k
- r
- p
- cumulative
NEGBINOMDIST(k, r, p, cumulative)Calculates the negative binomial distribution for the given parameters.
NETWORKDAYSDate- start_date
- end_date
- holidays
NETWORKDAYS(start_date, end_date, holidays)Returns the number of net working days between two dates, optionally excluding holidays
NETWORKDAYSINTLDate- 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.
NOMINALFinancial- rate
- periods
NOMINAL(rate, periods)Returns the nominal interest rate for an effective interest rate and number of compounding periods per year.
NORMDISTStatistical- x
- mean
- sd
- cumulative
NORMDIST(x, mean, sd, cumulative)Calculate the probability that variable x falls below or at a specified value. 
NORMINVStatistical- probability
- mean
- sd
NORMINV(probability, mean, sd)Calculate the inverse of the normal cumulative distribution for the specified mean and standard deviation.
NORMSDISTStatistical- z
- cumulative
NORMSDIST(z, cumulative)Calculates the Standard Normal Cumulative Distribution Function for a supplied value.
NORMSINVStatistical- probabilityNORMSINV(probability)Calculates the inverse of the Standard Normal Cumulative Distribution Function for a supplied probability value.
NOTLogical- logicalNOT(logical)Returns the opposite of a logical value.
NOWDateNOW()Returns the current date and time.
NPERFinancial- rate
- payment
- present
- future
- type
NPER(rate, payment, present, future, type)Returns the number of periods for an annuity.
NPVFinancialNPV()Returns the net present value of an annuity based on a series of periodic cash flows and a discount rate.
NUMBERSMathNUMBERS()Returna array with numbers only from a given range.
NUMBERVALUEMath- text,
- decimal_separator
- group_separator
NUMBERVALUE(text, decimal_separator, group_separator)Converts text to a number. Decimal and group separators are optional.
NUMERALMath- number
- format
NUMERAL(number, format)Returns number in a given format.
OCT2BINMath- number
- places
OCT2BIN(number, places)Converts an octal number to binary.
OCT2DECMath- numberOCT2DEC(number)Converts an octal number to decimal.
OCT2HEXMath- number
- places
OCT2HEX(number, places)Converts an octal number to hexadecimal.
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.
PDURATIONFinancial- rate
- present
- future
PDURATION(rate, present, future)Returns the number of periods required by an annuity to reach a specified value.
PEARSONStatistical- data_x
- data_y
PEARSON(data_x, data_y)Returns the Pearson product moment correlation coefficient.
PERCENTILEEXCMath- array
- k
PERCENTILEEXC(array, k)Returns the k'th percentile for a given range and k.
PERCENTILEINCMath- array
- k
PERCENTILEINC(array, k)Returns the k'th percentile for a given range and k.
PERCENTRANKEXCMath- array
- x
- significance
PERCENTRANKEXC(array, x, significance)Returns the relative position of a specified value within a given range.
PERCENTRANKINCMath- array
- x
- significance
PERCENTRANKINC(array, x, significance)Returns the relative position of a specified value within a given range.
PERMUTStatistical- number
- number_chosen
PERMUT(number, number_chosen)Returns the number of permutations for a given number of objects.
PERMUTATIONAStatistical- number
- number_chosen
PERMUTATIONA(number, number_chosen)Returns the number of permutations for a given number of objects.
PHIStatistical- xPHI(x)Returns the value of the density function for a standard normal distribution.
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.
POISSONDISTMath- x
- mean
- cumulative
POISSONDIST(x, mean, cumulative)Calculates the Poisson Probability Mass Function.
POWERMath- number
- power
POWER(number, power)Returns the number raised to a power.
PPMTFinancial- rate
- period
- periods
- present
- future
- type
PPMT(rate, period, periods, present, future, type)Calculates the payment on the principal of an investment.
PROBStatistical- range
- probability
- lower
- upper
PROB(range, probability, lower, upper)Returns the probability that values in a range are between two limits.
PRODUCTMathPRODUCT()Multiplies its arguments.
PROPERText- textPROPER(text)Capitalizes the first letter in each word of a text.
PVFinancial- rate
- periods
- payment
- future
- type
PV(rate, periods, payment, future, type)Returns the present value of an investment.
QUARTILEEXCMath- range
- quart
QUARTILEEXC(range, quart)Returns the quartile of a given range.
QUARTILEINCMath- range
- quart
QUARTILEINC(range, quart)Returns the quartile of a given range.
QUOTIENTMath- numerator
- denominator
QUOTIENT(numerator, denominator)Returns the integer portion of a division.
RADIANSMath- numberRADIANS(number)Converts an angle to radians.
RANDMathRAND()Returns a random number between 0 and 1.
RANDBETWEENMath- bottom
- top
RANDBETWEEN(bottom, top)Returns a random number between the numbers.
RANKAVGStatistical- number
- range
- order
RANKAVG(number, range, order)Returns the statistical rank of a given value in a range.
RANKEQStatistical- number
- range
- order
RANKEQ(number, range, order)Returns the statistical rank of a given value in a range.
RATEFinancial- periods
- payment
- present
- future
- type
- guess
RATE(periods, payment, present, future, type, guess)Returns the interest rate per period of an annuity.
REGEXEXTRACTText- text
- regular_expression
REGEXEXTRACT(text, regular_expression)Extracts matching substrings according to a regular expression.
REGEXMATCHText- text
- regular_expression
- full
REGEXMATCH(text, regular_expression, full)Checks if the text matches a regular expression.
REGEXREPLACEText- text
- regular_expression
- replacement
REGEXREPLACE(text, regular_expression, replacement)Replaces part of a text string with a different text string using regular expressions.
REPLACEText- text
- position
- length
- new_text
REPLACE(text, position, length, new_text)Replaces characters within text.
REPTText- text
- number
REPT(text, number)Repeats text a given number of times.
RIGHTText- text
- number
RIGHT(text, number)Returns a substring from the end of a specified string.
ROMANText- numberROMAN(number)Converts an arabic numeral to roman (as text).
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.
SHEETLookup- sheet_number
- cell_range
SHEET(sheet_number, cell_range)Returns the value or range from another sheet in the spreadsheet.
RRIFinancial- periods
- present
- future
RRI(periods, present, future)Calculates an equivalent interest rate for the growth of an annuity.
RSQStatistical- data_x
- data_y
RSQ(data_x, data_y)Calculates the square of the Pearson product moment correlation coefficient.
SEARCHText- find_text
- within_text
- position
SEARCH(find_text, within_text, position)Finds one text value within another (non case-sensitive)
SECMath- numberSEC(number)Returns the secant of an angle ( radians).
SECHMath- numberSECH(number)Returns the hyperbolic secant of an angle.
SECONDDate- dateSECOND(date)Returns the second component of a given time.
SERIESSUMMath- x
- n
- m
- coefficients
SERIESSUM(x, n, m, coefficients)Returns the sum of a power series based on the formula.
SIGNMath- numberSIGN(number)Returns the sign of a number.
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).
SKEWStatisticalSKEW()Returns the skewness of a distribution.
SKEWPStatisticalSKEWP()Returns the skewness of a distribution based on a population.
SLNFinancial- cost
- salvage
- life
SLN(cost, salvage, life)Returns the depreciation of an asset for one period.
SLOPEStatistical- data_y
- data_x
SLOPE(data_y, data_x)Returns the slope of the linear regression line.
SMALLStatistical- array
- k
SMALL(array, k)Returns the k-th smallest value in a range.
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.
STANDARDIZEStatistical- x
- mean
- sd
STANDARDIZE(x, mean, sd)Returns a normalized value.
STDEVAStatisticalSTDEVA()Calculates standard deviation based on a sample, including numbers, text, and logical values.
STDEVPStatisticalSTDEVP()Calculates standard deviation based on the entire population.
STDEVPAStatisticalSTDEVPA()Calculates standard deviation based on the entire population, including numbers, text, and logical values.
STDEVSStatisticalSTDEVS()Calculates the sample standard deviation for the supplied values.
STEYXStatistical- data_y
- data_x
STEYX(data_y, data_x)Returns the standard error of the regression.
STRINGText- valueSTRING(value)Returns a string from value.
SUBSTITUTEText- text
- old_text
- new_text
- occurrence
SUBSTITUTE(text, old_text, new_text, occurrence)Replaces existing text with new text in a string.
SUBTOTALMath- function_codeSUBTOTAL(function_code)Returns an aggregate result for supplied values.
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.
SUMPRODUCTArray- 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.
SUMX2MY2Array- array_x
- array_y
SUMX2MY2(array_x, array_y)Calculates the sum of the differences of the squares of values in two arrays.
SUMX2PY2Array- array_x
- array_y
SUMX2PY2(array_x, array_y)Calculates the sum of the sums of the squares of corresponding items in the arrays.
SUMXMY2Array- array_x
- array_y
SUMXMY2(array_x, array_y)Calculates the sum of the squares of the differences between corresponding items in the arrays.
SWITCHLogicalSWITCH()Compares one value against a list of values, and returns a result corresponding to the first match.
SYDFinancial- cost
- salvage
- life
- period
SYD(cost, salvage, life, period)Calculates the depreciation of an asset for a specified period.
TText- valueT(value)Returns string arguments as text.
TANMath- numberTAN(number)Returns the tangent of a number (in radians)
TANHMath- numberTANH(number)Returns the hyperbolic tangent of a number.
TBILLEQFinancial- settlement
- maturity
- discount
TBILLEQ(settlement, maturity, discount)Calculates the bond-equivalent yield for Treasury Bill.
TBILLPRICEFinancial- settlement
- maturity
- discount
TBILLPRICE(settlement, maturity, discount)Calculates the price of Treasury Bill based on discount rate.
TBILLYIELDFinancial- settlement
- maturity
- price
TBILLYIELD(settlement, maturity, price)Calculates the yield of Treasury Bill.
TDISTStatistical- x
- df
- cumulative
TDIST(x, df, cumulative)Calculates the Student's T Distribution.
TEXTText- value
- format
TEXT(value, format)Converts a value into text based on a specified format.
TIMEDate- hour
- minute
- second
TIME(hour, minute, second)Converts an hour, minute, and second into a time.
TIMEVALUEDate- time_textTIMEVALUE(time_text)Converts a text representing a date, into a fraction of a 24-hour day.
TINVStatistical- probability
- df
TINV(probability, df)Calculates the inverse of the two-tailed Student's T Distribution.
TODAYDateTODAY()Returns current date.
TRIMText- textTRIM(text)Removes leading and trailing spaces from text.
TRIMMEANStatistical- range
- percent
TRIMMEAN(range, percent)Calculates mean of a range while excluding outliers.
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.
UNFLATTENMath- array
- numOfCols
UNFLATTEN(array, numOfCols)Converts one dimensional array into multidimensional array based on the number of columns.
UNICHARText- numberUNICHAR(number)Returns the Unicode character based a given number.
UNICODEText- textUNICODE(text)Returns the code for the first character of a text.
UNIQUEFilter- rangeUNIQUE(range)Returns unique rows in the provided range.
UPPERText- textUPPER(text)Convert text to all capital letters.
VALIDBINMath- numberVALIDBIN(number)Checks if value is in binary format.
VALUEText- textVALUE(text)Converts text into a number.
VARAStatistical- number1
- [number2]
...
VARA(value1, [value2],...)Calculates the sample variance of a set of values.
VARPStatistical- value1
- [value2]
...
VARP(value1, [value2],...)Returns the variance of a set of values.
VARPAStatistical- value1
- [value2]
...
VARPA(value1, value2,...)Calculates the variance based on an entire population.
VARSStatistical- value1
- [value2]
...
VARS(value1, [value2],...)Calculates the variance of a sample of data.
VLOOKUPSearch- table
- value
- index
- exactmatch
VLOOKUP(table, value, index, exactmatch)Searches down and retrieve data from a specific column in table.
WEEKDAYDate- date
- type
WEEKDAY(date, type)Returns a number between 1-7 representing the day of week.
WEEKNUMDate- date
- type
WEEKNUM(date, type)Returns a week number that corresponds to the week of year.
WEIBULLDISTStatistical- x
- alpha
- beta
- cumulative
WEIBULLDIST(x, alpha, beta, cumulative)Returns the value of the Weibull distribution function.
WORKDAYDate- start_date
- days
- holidays
WORKDAY(start_date, days, holidays)Returns the nearest working day in the future or past.
WORKDAYINTLDate- 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.
XIRRFinancial- 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.
XNPVFinancial- 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.
XORLogical- logical1
- [logical2]
...
XOR(logical1, [logical2], ...)Logical exclusive OR of all arguments.
YEARDate- dateYEAR(date)Returns the year from a given date.
YEARFRACDate- start_date
- end_date
- basis
YEARFRAC(start_date, end_date, basis)Returns a decimal value that represents fractional years between two dates.
ZTESTStatistical- 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.
 
%d bloggers like this: