ABSCompute the absolute value of a numberACCRINTReturns the accrued interest for a security that pays periodic interestACCRINTMReturns the accrued interest at maturity for a security that pays interest at maturityACOSCompute the arccosine of a number, returning an angle in radiansACOSHCompute the inverse hyperbolic cosine of a numberACOTReturns the arccotangent (inverse cotangent) of a number in radians.ACOTHReturns the inverse hyperbolic cotangent of a number.ADDAdds two numeric values (x+y)AMORLINCReturns the depreciation for each accounting period using a linear methodANDReturns TRUE if all of the values are TRUE, and FALSE otherwise.ARABICConverts a Roman numeral to an Arabic numeralARRAYCreates a range from a datatableARRAYFORMULAAllow array formulas to return multiple valuesASINCompute the arcsine of a number, returning an angle in radiansASINHCompute the inverse hyperbolic sine of a numberATANCompute the arctangent of a number, returning an angle in radiansATAN2Compute the arctangent of the given x and y coordinates, returning an angle in radians between PI and -PI, excluding -PIATANHCompute the inverse hyperbolic tangent of a numberAVEDEVCalculates the average of the absolute deviations of the given values from their meanAVERAGECalculates the average (arithmetic mean) of the given valuesAVERAGEIFCalculates the average (arithmetic mean) of all values in a range that meet a criterionAVERAGEIFSCalculates the average (arithmetic mean) of all values that meet multiple criteriaBAHTTEXTConverts a number to Thai text and adds a suffix of "Baht"BASEConverts a number into a text representation with the given radix (base)BESSELIReturns the modified Bessel function of the first kindBESSELJReturns the Bessel function of the first kindBESSELKReturns the modified Bessel function of the second kindBESSELYReturns the Bessel function of the second kindBETA.DISTReturns the beta distribution.BETA.INVReturns the inverse of the beta cumulative distribution.BETADISTLegacy compatibility form of BETA.DIST.BIN2DECConverts a binary number to decimalBIN2HEXConverts a binary number to hexadecimalBIN2OCTConverts a binary number to octalBINOM.DISTReturns the individual term binomial distribution probabilityBINOM.DIST.RANGEReturns the probability of a trial result using a binomial distributionBINOM.INVReturns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion valueBITANDReturns a bitwise AND of two numbersBITLSHIFTReturns a number shifted left by the specified number of bitsBITORReturns a bitwise OR of two numbersBITRSHIFTReturns a number shifted right by the specified number of bitsBITXORReturns a bitwise XOR of two numbersBUCKETCOUNTBucketizes data into a specified number of equally-sized buckets. Non-numeric values are ignored.BUCKETSIZEBucketizes data into a buckets of specified size. Non-numeric values are ignored.CEILINGRounds a number up to the nearest multiple of a specified factorCEILING.MATHRounds a number up to the nearest integer or multiple of significanceCEILING.PRECISERounds a number up to the nearest multiple of significanceCHARReturns the character specified by a numberCHISQ.DISTReturns the chi-squared distributionCHISQ.DIST.RTReturns the right-tailed probability of the chi-squared distributionCHISQ.INVReturns the inverse of the left-tailed probability of the chi-squared distributionCHISQ.INV.RTReturns the inverse of the right-tailed probability of the chi-squared distributionCHOOSEReturns the value at the specified position in a list of valuesCLEANRemoves nonprintable characters from textCODEReturns the numeric code for the first character in the text.COLUMNReturns the column number of the cell containing the formula. If given a reference, returns the column number of the reference.COLUMNSCompute the number of columns in a rangeCOMBINReturns the number of combinations for a given number of items.COMBINAReturns the number of combinations with repetitions for a given number of items.CONCATConcatenates a list of values into a single text valueCONFIDENCE.NORMReturns the confidence interval for a population mean using a normal distribution.CONFIDENCE.TReturns the confidence interval for a population mean using a t distribution.CONVERTConverts a number from one measurement unit to anotherCOSCompute the cosine of an angle in radiansCOSHReturns the hyperbolic cosine of a numberCOTReturns the cotangent of an angle specified in radians.COTHReturns the hyperbolic cotangent of a number.COUNTCounts the number of non-empty numeric or temporal valuesCOUNTACounts the number of non-empty valuesCOUNTBLANKCounts the number of empty cells in a rangeCOUNTIFCounts the number of cells within a range that meet a criterionCOUNTIFSCounts the number of cells within a range that meet multiple criteriaCOUNTUNIQUECounts the number of unique values in a rangeCOUNTUNIQUEIFSCounts the number of unique values in a range that meet multiple criteriaCOUPDAYSReturns the number of days in the coupon period that contains the settlement dateCOUPDAYSNCReturns the number of days from the settlement date to the next coupon dateCOUPNCDReturns the next coupon date after the settlement dateCOUPNUMReturns the number of coupons payable between the settlement and maturity datesCOUPPCDReturns the previous coupon date before the settlement dateCSCReturns the cosecant of an angle specified in radians.CSCHReturns the hyperbolic cosecant of a number.CUMIPMTReturns the cumulative interest paid between two periodsCUMPRINCReturns the cumulative principal paid between two periodsDATATABLECreates a data tableDATECreate a date from its componentsDATEDIFReturns the difference between two dates in the requested unitsDATEPARTExtract the date part of a datetimeDATEVALUEConverts a date in text format to a date valueDAYReturns the numeric (1-31) day of the monthDAYSReturns the number of days between two datesDAYS360Returns the number of days between two dates based on a 360-day year (12 30-day months)DBReturns the depreciation of an asset for a specified period using the fixed-declining balance methodDDBReturns the depreciation of an asset for a specified period using the double-declining balance methodDEC2BINConverts a decimal number to binaryDEC2HEXConverts a decimal number to hexadecimalDEC2OCTConverts a decimal number to octalDECIMALConverts a text representation of a number in a given base into a decimal numberDEGREESConvert an angle from radians to degreesDELTATests whether two values are equal.DISCReturns the discount rate for a securityDIVIDEDivides the first numeric value by the second (x/y)DOLLARDEConverts a fractional dollar amount to a decimal dollar amountDOLLARFRConverts a decimal dollar amount to a fractional dollar amountEDATEReturns a date some number of months before or after a given dateEFFECTReturns the effective annual interest rate from a nominal rate and compounding periodsEOMONTHReturns the last day of the month a number of months before or after a given dateERFReturns the error function valueERF.PRECISEReturns the error function value using a precise algorithmERFCReturns the complementary error function valueERROR.TYPEReturns a number corresponding to an error typeEVENRounds a number up to the nearest even integerEXACTCompare two strings for exact, case-sensitive equalityEXPCompute e to the power of a number (e^x)EXPON.DISTReturns the exponential distribution.EXTRACTCOLUMNNAMEReturns the column name of a column as textF.DISTReturns the F probability distributionF.DIST.RTReturns the right-tailed F probability distributionF.INVReturns the inverse of the F probability distributionF.INV.RTReturns the inverse of the right-tailed F probability distributionFACTReturns the factorial of a numberFACTDOUBLEReturns the double factorial of a numberFALSEReturns the logical value FALSEFILTERFilters a range based on a conditionFINDFinds one text value within another (case-sensitive) and returns the position of the found text (starting at 1)FISHERReturns the Fisher transformation.FISHERINVReturns the inverse Fisher transformation.FIXEDRounds a number and returns it as text with optional commasFLATTENFlattens the values from one or more ranges in row-major order into a single columnFLOORRounds a number down to the nearest multiple of a specified factorFLOOR.MATHRounds a number down to the nearest integer or multiple of significanceFLOOR.PRECISERounds a number down to the nearest multiple of significanceFORECASTPredicts a y value at a given x using linear regression on known data pointsFREQUENCYCalculates how often values occur within a range of values. Non-numeric values are ignored.FVReturns the future value of an investmentGAMMAReturns the gamma function value.GAMMA.DISTReturns the gamma distribution.GAMMA.INVReturns the inverse gamma cumulative distribution.GAMMALNReturns the natural log of the gamma function.GAMMALN.PRECISEReturns the natural log of the gamma function.GAUSSReturns the probability that a standard normal variable lies between 0 and z.GCDReturns the greatest common divisor of two or more integersGESTEPTests whether a number is greater than or equal to a threshold value.GLUEConcatenates a list of values into a single text value with a delimiter between each valueHEX2BINConverts a hexadecimal number to binaryHEX2DECConverts a hexadecimal number to decimalHEX2OCTConverts a hexadecimal number to octalHISTOGRAMCompute the unique values from a specified range and how many times each value appearsHOURReturns the hour (0-23) of a timeHSTACKStacks multiple ranges horizontallyHYPGEOM.DISTReturns the hypergeometric distribution.HYPGEOMDISTLegacy compatibility form of HYPGEOM.DIST.IFReturn the first value if the condition is TRUE and the second value if the condition is FALSEIFERRORReturns the first argument if it is not an error, otherwise returns the second argumentIFNAReturns the first argument if it is not #N/A, otherwise returns the second argumentIFSReturn the first value for which the condition is TRUEIMPORTRANGEImports data from a range in another workbookINDEXReturn the value from a range at the given row and columnINTConverts a number to an integer by rounding down, and parses strings into integersINTRATEReturns the interest rate for a fully invested securityIPMTReturns the interest component of a payment for a specific periodIRRReturns the internal rate of return for a series of cash flowsISBLANKReturns true if the value is blank, otherwise returns falseISERRReturns true if the value is an error (excluding #N/A), otherwise returns falseISERRORReturns true if the value is an error, otherwise returns falseISEVENReturns TRUE if number is even, or FALSE if number is odd.ISLOGICALReturns TRUE if the value is a logical value (TRUE or FALSE), or FALSE otherwise.ISNAReturns true if the value is an #N/A error, otherwise returns falseISNONTEXTReturns TRUE if the value is not text, or FALSE otherwise.ISNUMBERReturns TRUE if the value is a number, a date, or a time value. Returns FALSE otherwise.ISO.CEILINGRounds a number up to the nearest multiple of significanceISODDReturns TRUE if number is odd, or FALSE if number is even.ISOWEEKNUMReturns the ISO week number of a dateISOYEARReturns the ISO week-numbering year for a dateISPMTReturns the interest payment for a specific period of an investment with even principal paymentsISREFReturns TRUE if the argument is a referenceISTEXTReturns TRUE if the value is text, or FALSE otherwise.JSONEXTRACTExtracts a from a JSON object based on a hierarchical field pathKINDReturns the kind of value as textLARGECompute the nth largest value in a rangeLCMReturns the least common multiple of two or more integersLEFTReturns the first N characters from some textLENCompute the number of characters in a valueLINESTFits a linear regression and returns coefficients with optional statisticsLNCompute the natural logarithm of a positive numberLOGCompute the logarithm of a number to a specified baseLOG10Returns the base-10 logarithm of a numberLOGNORM.DISTReturns the log-normal cumulative distribution function or probability density functionLOGNORM.INVReturns the inverse of the lognormal cumulative distribution functionLOWERConverts text to lowercaseMAKEERRORCreates an error valueMATCHCompute the row index of a value in a rangeMAXCompute the largest numeric or temporal valueMAXIFSReturns the maximum value in a range that meets multiple criteriaMDURATIONReturns the modified Macaulay duration of a security with an assumed par value of 100MEDIANCompute the median of the given valuesMIDReturns the specified number of characters from some text starting at the specified positionMINCompute the smallest numeric or temporal valueMINIFSReturns the minimum value in a range that meets multiple criteriaMINUSSubtracts the second numeric value from the first (x-y)MINUTEReturns the minute (0-59) of a timeMODReturns the remainder of a divisionMODEReturns the most common number in the given valuesMONTHReturns the month (1-12) of a dateMROUNDRounds a number to the nearest specified multipleMULTILOOKUPReturn the first row from the return range where all the keys match the specified values in the key rangesMULTIPLYMultiplies two numeric values (x*y)NConverts a value to a numberNAReturns the #N/A errorNEGBINOM.DISTReturns the negative binomial distribution.NEGBINOMDISTLegacy compatibility form of NEGBINOM.DIST.NETWORKDAYSReturns the number of whole workdays between two datesNETWORKDAYS.INTLReturns the number of whole workdays between two dates with custom weekend parametersNOMINALReturns the nominal annual interest rate from an effective rate and compounding periodsNORM.DISTReturns the normal distribution for the specified mean and standard deviationNORM.INVReturns the inverse of the normal cumulative distribution for the specified mean and standard deviationNORM.S.DISTReturns the standard normal distribution (with mean of 0 and standard deviation of 1)NORM.S.INVReturns the inverse of the standard normal cumulative distribution (with mean of 0 and standard deviation of 1)NOTReverses the logical value of its argument. Returns TRUE if the argument is FALSE and returns FALSE if the argument is TRUE.NOWReturns the current date and time in the timezone configured in workbook settingsNPERReturns the number of periods needed for payments to reach a goalNPVReturns the net present value of an investmentNUMBERVALUEParses text into a numberOBJECTCreates a JSON objectOCT2BINConverts an octal number to binaryOCT2DECConverts an octal number to decimalOCT2HEXConverts an octal number to hexadecimalODDRounds a number up to the nearest odd integerODDFPRICEReturns the price per $100 face value of a security with an odd first coupon periodODDFYIELDReturns the yield of a security with an odd first coupon periodODDLPRICEReturns the price per $100 face value of a security with an odd last coupon periodODDLYIELDReturns the yield of a security with an odd last coupon periodORReturns TRUE if any of the values are TRUE, and FALSE otherwise.PARSEParses text into a value, as if it were typed into a cellPDURATIONReturns the number of periods required for an investment to reach a specified future valuePERCENTILECompute the specified percentile of the given valuesPERMUTReturns the number of permutations for a given number of objects.PERMUTATIONAReturns the number of permutations for a given number of objects (with repetition allowed).PHIReturns the standard normal probability density function.PIThe constant pi (π)PMTReturns the payment for an annuityPOISSON.DISTReturns the Poisson distribution.POWERCompute the result of a number raised to a power (x^y)PPMTReturns the principal component of a payment for a specific periodPRICEDISCReturns the price per $100 face value of a discounted securityPRICEMATReturns the price per $100 face value of a security that pays interest at maturityPRODUCTComputes the product of the numeric valuesPROPERCapitalizes the first letter in a text and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase lettersPVReturns the present value of an investmentQUARTILEReturns the quartile of a datasetQUOTIENTReturns the integer portion of a divisionRADIANSConvert an angle from degrees to radiansRANDReturns a random number between 0 (inclusive) and 1 (exclusive)RANDARRAYReturns an array of random numbers between the specified minimum and maximum valuesRANDBETWEENReturns a random number between the specified minimum and maximum valuesRANKCompute the rank of a number in a rangeRANK.EQCompute the rank of a number in a rangeRATEReturns the interest rate per period of an annuityRECEIVEDReturns the amount received at maturity for a fully invested securityREGEXEXTRACTExtracts text based on a supplied regular expressionREGEXREPLACEReplaces text based on a supplied regular expressionREGEXTESTTests if a text matches a regular expressionREPLACEReplaces part of a text with another textREPTRepeats text a given number of times.RIGHTReturns the last N characters in some textROMANConverts an Arabic numeral to Roman, as textROUNDRounds a number to a specified number of digitsROUNDDOWNRounds a number down towards zero to a specified number of digitsROUNDUPRounds a number up away from zero to a specified number of digitsROWReturns the row number of the cell containing the formula, or the row in the data table column. If given a reference, returns the row number of the reference.ROWSCompute the number of rows in a rangeRRIReturns the equivalent interest rate for an investment over a number of periods.SEARCHFinds one text value within another (case-insensitive) and returns the position of the found text (starting at 1)SECReturns the secant of an angle specified in radians.SECHReturns the hyperbolic secant of a number.SECONDReturns the second (0-59) of a timeSECONDSConverts a number of seconds into a duration valueSELECTCOLUMNSSelects columns from a data table to form a new data tableSEQUENCEReturns an array of sequential numbersSIGNDetermines the sign of a number: returns 1 if positive, 0 if zero, and -1 if negativeSINCompute the sine of an angle in radiansSINHReturns the hyperbolic sine of a numberSLNReturns the straight-line depreciation of an asset for one periodSLOPEReturns the slope of the linear regression line through known data pointsSMALLCompute the nth smallest value in a rangeSMARTSAMPLESamples a specified number of (x1, x2, ... xN) tuples from the given columns or ranges, making an effort to retain outliers. This is useful for any visual inspection of large datasets and things like scatter plots.SORTSorts the contents of a rangeSORTBYSorts the contents of a range or array based on values in a corresponding range or arraySQRTCompute the square root of a numberSQRTPIReturns the square root of (number * pi)STANDARDIZEReturns a normalized value (z-score).STDEVCompute sample standard deviation of the given values (divides by n-1)STDEV.PCompute population standard deviation of the given values (divides by n)STDEV.SCompute sample standard deviation of the given values (divides by n-1)SUBSTITUTEReplaces occurrences of a specified substring within text with another substringSUBTOTALComputes a subtotal for a range using a specified function numberSUMComputes a sum of the numeric valuesSUMIFSums the values in a range that meet a criterionSUMIFSSums the values in a range that meet multiple criteriaSUMPRODUCTCompute the sum of the product of corresponding values in the given rangesSWITCHMatch an expression against a list of values and return the corresponding resultSYDReturns the sum-of-years' digits depreciation of an asset for a specified periodTReturns the value if it is text; otherwise returns empty textT.DISTReturns the Student's t-distributionT.DIST.2TReturns the two-tailed Student's t-distributionT.DIST.RTReturns the right-tailed probability of Student's t-distribution.T.INVReturns the left-tailed inverse of the Student's t-distributionT.INV.2TReturns the two-tailed inverse of the Student's t-distributionT.TESTReturns the probability associated with a Student's t-testTANCompute the tangent of an angle in radiansTANHReturns the hyperbolic tangent of a numberTBILLEQReturns the bond-equivalent yield for a treasury billTBILLPRICEReturns the price per $100 face value for a Treasury billTBILLYIELDReturns the yield for a Treasury billTDISTLegacy compatibility form of Student's t-distribution probability.TEXTFormats a value as text according to the format patternTEXTAFTERReturns text that occurs after a given delimiterTEXTBEFOREReturns text that occurs before a given delimiterTEXTJOINConcatenates a list of values into a single text value, with a specified delimiterTEXTSPLITSplits text into an array of substrings based on a delimiterTIMECreate a time value from hour, minute, and second componentsTIMEPARTExtract the time part of a datetimeTIMEVALUEConverts a time in text format to a time valueTODAYReturns the current date in the timezone configured in workbook settingsTRANSPOSETransposes a rangeTRIMRemoves all spaces from text except for single spaces between wordsTRUEReturns the logical value TRUETRUNCTruncates a number to an integer by removing the fractional partTYPEReturns a number that identifies the type of a value.TYPEDUNIQUECompute a list of unique values from a specified rangeUNICHARReturns the Unicode character for the given numeric value.UNICODEReturns the Unicode number for the first character of the text.UNIQUECompute a list of unique rows or columns from a specified rangeUPPERConverts text to uppercaseVALUEParses text into a numberVARCompute sample variance of the given values (divides by n-1)VAR.PCompute population variance of the given values (divides by n)VAR.SCompute sample variance of the given values (divides by n-1)VDBReturns the depreciation of an asset for a specified period using a declining balance methodVLOOKUPSearches for a value in the first column the given range and returns the value in the same row from the specified columnVSTACKStacks multiple ranges verticallyWEEKDAYReturns the weekday for a dateWEEKNUMReturns the week number of a dateWEIBULL.DISTReturns the Weibull distributionWILDCARDESCAPETransforms text so the wildcard characters ? and * no long trigger the pattern matcherWORKDAYReturns a date that is the specified number of working days before or after a dateWORKDAY.INTLReturns a date that is the specified number of working days before or after a date with custom weekend parametersXIRRReturns the internal rate of return for a schedule of cash flows that are not necessarily periodic.XLOOKUPSearch for a value in the lookup range and return the corresponding value from the return rangeXMATCHCompute the position of a value in a rangeXNPVReturns the net present value of an investment based on a specified dateXORReturns TRUE if an odd number of values are TRUE, and FALSE otherwise.YEARReturns the year of a date valueYEARFRACReturns the fraction of a year between two datesYIELDMATReturns the annual yield of a security that pays interest at maturity