TypeFewer LettersMore Letters
Acronym ACCRINT [Calculates the accrued interest of a security that has periodic payments](https://support.google.com/docs/answer/3093200)
Acronym ACCRINTM [Calculates the accrued interest of a security that pays interest at maturity](https://support.google.com/docs/answer/3093202)
Acronym ACOTH [Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.](https://support.google.com)
Acronym ADD [Returns the sum of two numbers. Equivalent to the + operator](https://support.google.com/docs/answer/3093590)
Acronym AMORLINC [Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.](https://support.google.com)
Acronym AND [Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false](https://support.google.com/docs/answer/3093301)
Acronym ARRAYFORMULA [Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays](https://support.google.com/docs/answer/3093275)
Acronym ASC [Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.](https://support.google.com)
Acronym ATAN2 [Returns the angle between the x-axis and a line segment from the origin (0,0) to specified coordinate pair (x,y), in radians](https://support.google.com/docs/answer/3093468)
Acronym AVEDEV [Calculates the average of the magnitudes of deviations of data from a dataset's mean](https://support.google.com/docs/answer/3093613)
Acronym AVERAGE [Returns the numerical average value in a dataset, ignoring text](https://support.google.com/docs/answer/3093615)
Acronym AVERAGE.WEIGHTED [Finds the weighted average of a set of values, given the values and the corresponding weights.](https://support.google.com/docs/answer/9084098)
Acronym AVERAGEIFS [Returns the average of a range depending on multiple criteria](https://support.google.com/docs/answer/3256534)
Acronym BASE [Converts a number into a text representation in another base, for example, base 2 for binary.](https://support.google.com)
Acronym BETA.DIST [Returns the probability of a given value as defined by the beta distribution function.](https://support.google.com)
Acronym BETA.INV [Returns the value of the inverse beta distribution function for a given probability.](https://support.google.com)
Acronym BETADIST [Returns the probability of a given value as defined by the beta distribution function.](https://support.google.com)
Acronym BETAINV [Returns the value of the inverse beta distribution function for a given probability.](https://support.google.com)
Acronym BINOMDIST [Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws](https://support.google.com/docs/answer/3093987)
Acronym BITAND [Bitwise boolean AND of two numbers.](https://support.google.com)
Acronym BITLSHIFT [Shifts the bits of the input a certain number of places to the left.](https://support.google.com)
Acronym BITOR [Bitwise boolean OR of two numbers.](https://support.google.com)
Acronym BITRSHIFT [Shifts the bits of the input a certain number of places to the right.](https://support.google.com)
Acronym BITXOR [Bitwise boolean XOR (exclusive or) of two numbers.](https://support.google.com)
Acronym CEILING [Rounds a number up to the nearest integer multiple of specified significance](https://support.google.com/docs/answer/3093471)
Acronym CEILING.MATH [Rounds a number up to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.](https://support.google.com)
Acronym CEILING.PRECISE [Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded up.](https://support.google.com)
Acronym CHAR [Convert a number into a character according to the current Unicode table](https://support.google.com/docs/answer/3094120)
Acronym CHIDIST [Calculates the right-tailed chi-squared distribution, often used in hypothesis testing](https://support.google.com/docs/answer/7003346)
Acronym CHISQ.DIST [Calculates the left-tailed chi-squared distribution, often used in hypothesis testing](https://support.google.com/docs/answer/7003347)
Acronym CHISQ.DIST.RT [Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing](https://support.google.com/docs/answer/7003199)
Acronym CHITEST [Returns the probability associated with a Pearsonâ€™s chi-squared test on the two ranges of data. Determines the likelihood that the observed categorical data is drawn from an expected distribution](https://support.google.com/docs/answer/7004263)
Acronym CHOOSE [Returns an element from a list of choices based on index](https://support.google.com/docs/answer/3093371)
Acronym CODE [Returns the numeric Unicode map value of the first character in the string provided](https://support.google.com/docs/answer/3094122)
Acronym COLUMN [Returns the column number of a specified cell, with A=1](https://support.google.com/docs/answer/3093373)
Acronym COLUMNS [Returns the number of columns in a specified array or range](https://support.google.com/docs/answer/3093374)
Acronym COMBIN [Returns the number of ways to choose some number of objects from a pool of a given size of objects](https://support.google.com/docs/answer/3093400)
Acronym COMBINA [Returns the number of ways to choose some number of objects from a pool of a given size of objects, including ways that choose the same object multiple times.](https://support.google.com)
Acronym CONCAT [Returns the concatenation of two values. Equivalent to the & operator](https://support.google.com/docs/answer/3093592)
Acronym CONFIDENCE [Calculates the width of half the confidence interval for a normal distribution](https://support.google.com/docs/answer/3093988)
Acronym CONFIDENCE.NORM [Calculates the width of half the confidence interval for a normal distribution.](https://support.google.com)
Acronym CONVERT [Converts a numeric value to a different unit of measure](https://support.google.com/docs/answer/6055540)
Acronym CORREL [Calculates r, the Pearson product-moment correlation coefficient of a dataset](https://support.google.com/docs/answer/3093990)
Acronym COUNT [Returns the a count of the number of numeric values in a dataset](https://support.google.com/docs/answer/3093620)
Acronym COUNTA [Returns the a count of the number of values in a dataset](https://support.google.com/docs/answer/3093991)
Acronym COUNTBLANK [Returns the number of empty cells in a given range](https://support.google.com/docs/answer/3093403)
Acronym COUNTIFS [Returns the count of a range depending on multiple criteria](https://support.google.com/docs/answer/3256550)
Acronym COUNTUNIQUE [Counts the number of unique values in a list of specified values and ranges](https://support.google.com/docs/answer/3093405)
Acronym COUPDAYBS [Calculates the number of days from the first coupon, or interest payment, until settlement](https://support.google.com/docs/answer/3093154)
Acronym COUPDAYS [Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date](https://support.google.com/docs/answer/3093204)
Acronym COUPDAYSNC [Calculates the number of days from the settlement date until the next coupon, or interest payment](https://support.google.com/docs/answer/3093156)
Acronym COUPNCD [Calculates next coupon, or interest payment, date after the settlement date](https://support.google.com/docs/answer/3093157)
Acronym COUPNUM [Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment](https://support.google.com/docs/answer/3093208)
Acronym COUPPCD [Calculates last coupon, or interest payment, date before the settlement date](https://support.google.com/docs/answer/3093210)
Acronym CRITBINOM [Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria](https://support.google.com/docs/answer/3093623)
Acronym CSCH [The CSCH function returns the hyperbolic cosecant of any real number](https://support.google.com/docs/answer/9116336)
Acronym CUMIPMT [Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093211)
Acronym CUMPRINC [Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093159)
Acronym DATE [Converts a provided year, month, and day into a date](https://support.google.com/docs/answer/3092969)
Acronym DATEDIF [Calculates the number of days, months, or years between two dates](https://support.google.com/docs/answer/6055612)
Acronym DATEVALUE [Converts a provided date string in a known format to a date value](https://support.google.com/docs/answer/3093039)
Acronym DAVERAGE [Returns the average of a set of values selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094144)
Acronym DAY [Returns the day of the month that a specific date falls on, in numeric format](https://support.google.com/docs/answer/3093040)
Acronym DAYS [Returns the number of days between two dates.](https://support.google.com)
Acronym DAYS360 [Returns the difference between two days based on the 360 day year used in some financial interest calculations](https://support.google.com/docs/answer/3093042)
Acronym DB [Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method](https://support.google.com/docs/answer/3093162)
Acronym DCOUNT [Counts numeric values selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094222)
Acronym DCOUNTA [Counts values, including text, selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094147)
Acronym DDB [Calculates the depreciation of an asset for a specified period using the double-declining balance method](https://support.google.com/docs/answer/3093163)
Acronym DECIMAL [Converts the text representation of a number in another base, to base 10 (decimal).](https://support.google.com)
Acronym DETECTLANGUAGE [Identifies the language used in text within the specified range](https://support.google.com/docs/answer/3093278)
Acronym DEVSQ [Calculates the sum of squares of deviations based on a sample](https://support.google.com/docs/answer/3093625)
Acronym DGET [Returns a single value from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094148)
Acronym DISC [Calculates the discount rate of a security based on price](https://support.google.com/docs/answer/3093216)
Acronym DIVIDE [Returns one number divided by another. Equivalent to the / operator](https://support.google.com/docs/answer/3093973)
Acronym DMAX [Returns the maximum value selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094227)
Acronym DMIN [Returns the minimum value selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094149)
Acronym DOLLARDE [Converts a price quotation given as a decimal fraction into a decimal value](https://support.google.com/docs/answer/3093167)
Acronym DOLLARFR [Converts a price quotation given as a decimal value into a decimal fraction](https://support.google.com/docs/answer/3093217)
Acronym DPRODUCT [Returns the product of values selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094230)
Acronym DSTDEV [Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094151)
Acronym DSTDEVP [Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094280)
Acronym DSUM [Returns the sum of values selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094281)
Acronym DURATION [Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value](https://support.google.com/docs/answer/3093169)
Acronym DVAR [Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094236)
Acronym DVARP [Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query](https://support.google.com/docs/answer/3094238)
Acronym EDATE [Returns a date a specified number of months before or after another date](https://support.google.com/docs/answer/3092974)
Acronym EFFECT [Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year](https://support.google.com/docs/answer/3093223)
Acronym EOMONTH [Returns a date representing the last day of a month which falls a specified number of months before or after another date](https://support.google.com/docs/answer/3093044)
Acronym EQ [Returns TRUE if two specified values are equal and FALSE otherwise. Equivalent to the == operator](https://support.google.com/docs/answer/3093593)
Acronym ERF [Returns the result of the Gauss error function.](https://support.google.com)
Acronym ERROR.TYPE [Returns a number corresponding to the error value in a different cell](https://support.google.com/docs/answer/3238305)
Acronym EXPON.DIST [Returns the value of the exponential distribution function with a specified lambda at a specified value.](https://support.google.com)
Acronym EXPONDIST [Returns the value of the exponential distribution function with a specified lambda at a specified value](https://support.google.com/docs/answer/3093995)
Acronym F.DIST [Calculates the left-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution](https://support.google.com/docs/answer/6055706)
Acronym F.DIST.RT [Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution](https://support.google.com/docs/answer/6055799)
Acronym F.INV [Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecorâ€™s F distribution](https://support.google.com/docs/answer/7004265)
Acronym F.INV.RT [Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecorâ€™s F distribution](https://support.google.com/docs/answer/7003960)
Acronym F.TEST [Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance](https://support.google.com/docs/answer/7004267)
Acronym FALSE [Returns the logical value FALSE](https://support.google.com/docs/answer/3093302)
Acronym FDIST [Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately called Fisher-Snedecor distribution or Snedecor's F distribution](https://support.google.com/docs/answer/6055696)
Acronym FILTER [Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions](https://support.google.com/docs/answer/3093197)
Acronym FIND [Returns the position at which a string is first found within text](https://support.google.com/docs/answer/3094126)
Acronym FINDB [Returns the position at which a string is first found within text counting each double-character as 2](https://support.google.com/docs/answer/3296009)
Acronym FINV [Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecorâ€™s F distribution](https://support.google.com/docs/answer/7014062)
Acronym FIXED [Formats a number with a fixed number of decimal places](https://support.google.com/docs/answer/3094075)
Acronym FLATTEN [Flattens all the values from one or more ranges into a single column.](https://www.google.com/docs/answer/10307761)
Acronym FLOOR [Rounds a number down to the nearest integer multiple of specified significance](https://support.google.com/docs/answer/3093487)
Acronym FLOOR.MATH [Rounds a number down to the nearest integer multiple of specified significance, with negative numbers rounding toward or away from 0 depending on the mode.](https://support.google.com)
Acronym FLOOR.PRECISE [Rounds a number down to the nearest integer multiple of specified significance. If the number is positive or negative, it is rounded down.](https://support.google.com)
Acronym FORECAST [Calculates the expected y-value for a specified x based on a linear regression of a dataset](https://support.google.com/docs/answer/3094000)
Acronym FREQUENCY [Calculates the frequency distribution of a one-column array into specified classes](https://support.google.com/docs/answer/3094286)
Acronym FTEST [Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to have come from populations with the same variance](https://support.google.com/docs/answer/7004183)
Acronym FV [Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093224)
Acronym FVSCHEDULE [Calculates the future value of some principal based on a specified series of potentially varying interest rates](https://support.google.com/docs/answer/3093226)
Acronym GAMMA.INV [Returns the value of the inverse gamma cumulative distribution function for thespecified probability and alpha and beta parameters.](https://support.google.com)
Acronym GAMMAINV [Returns the value of the inverse gamma cumulative distribution function for thespecified probability and alpha and beta parameters.](https://support.google.com)
Acronym GAMMALN [Returns the the logarithm of a specified Gamma function, base e (Euler's number)](https://support.google.com/docs/answer/3093416)
Acronym GAUSS [Probability of a standard normal variable falling within z standard deviations of the mean.](https://support.google.com)
Acronym GCD [Returns the greatest common divisor of one or more integers](https://support.google.com/docs/answer/3093489)
Acronym GESTEP [Returns 1 if the rate is strictly greater than or equal to the provided step value or 0 otherwise. If no step value is provided then the default value of 0 will be used.](https://support.google.com)
Acronym GETPIVOTDATA [Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings](https://support.google.com/docs/answer/6167538)
Acronym GROWTH [Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values](https://support.google.com/docs/answer/3094287)
Acronym GT [Returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. Equivalent to the > operator](https://support.google.com/docs/answer/3098240)
Acronym GTE [Returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. Equivalent to the >= operator](https://support.google.com/docs/answer/3093975)
Acronym HLOOKUP [Horizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found](https://support.google.com/docs/answer/3093375)
Acronym HOUR [Returns the hour component of a specific time, in numeric format](https://support.google.com/docs/answer/3093045)
Acronym HYPGEOMDIST [Calculates the probability of drawing a certain number of successes in a certain number of tries given a population of a certain size containing a certain number of successes, without replacement of draws](https://support.google.com/docs/answer/3094004)
Acronym IF [Returns one value if a logical expression is TRUE and another if it is FALSE](https://support.google.com/docs/answer/3093364)
Acronym IFERROR [Returns the first argument if it is not an error value, otherwise returns the second argument if present, or a blank if the second argument is absent](https://support.google.com/docs/answer/3093304)
Acronym IFS [Evaluates multiple conditions and returns a value that corresponds to the first true condition.](https://support.google.com/docs/answer/7014145)
Acronym IMARGUMENT [The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians.](https://support.google.com/docs/answer/9116360)
Acronym IMCOS [The IMCOS function returns the cosine of the given complex number. ](https://support.google.com/docs/answer/9116546)
Acronym IMLN [Returns the logarithm of a complex number, base e (Euler's number).](https://support.google.com/docs/answer/9000651)
Acronym IMPORTDATA [Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format](https://support.google.com/docs/answer/3093335)
Acronym IMPORTHTML [Imports data from a table or list within an HTML page](https://support.google.com/docs/answer/3093339)
Acronym IMPORTJSONAPI [Provides a custom function to selectively extract data from a JSON or GraphQL API.](https://github.com/qeet/importjsonapi) (Script)
Acronym IMPORTXML [Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds](https://support.google.com/docs/answer/3093342)
Acronym IMPRODUCT [Returns the result of multiplying a series of complex numbers together](https://support.google.com/docs/answer/7409679)
Acronym INDEX [Returns the content of a cell, specified by row and column offset](https://support.google.com/docs/answer/3098242)
Acronym INT [Rounds a number down to the nearest integer that is less than or equal to it](https://support.google.com/docs/answer/3093490)
Acronym INTERCEPT [Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0)](https://support.google.com/docs/answer/3093632)
Acronym INTRATE [Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself](https://support.google.com/docs/answer/3093174)
Acronym IPMT [Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093175)
Acronym IRR [Calculates the internal rate of return on an investment based on a series of periodic cash flows](https://support.google.com/docs/answer/3093231)
Acronym ISDATE [Returns whether a value is a date.](https://support.google.com)
Acronym ISERR [Checks whether a value is an error other than #N/A](https://support.google.com/docs/answer/3093348)
Acronym ISLOGICAL [Checks whether a value is TRUE or FALSE](https://support.google.com/docs/answer/3093351)
Acronym ISNA [Checks whether a value is the error #N/A](https://support.google.com/docs/answer/3093293)
Acronym ISOWEEKNUM [Returns the number of the ISO week of the year where the provided date falls](https://support.google.com/docs/answer/7368793)
Acronym ISPMT [Interest payment. Calculates the interest paid at a particular period of an investment.](https://support.google.com)
Acronym JOIN [Concatenates the elements of one or more one-dimensional arrays using a specified delimiter](https://support.google.com/docs/answer/3094077)
Acronym KURT [Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset](https://support.google.com/docs/answer/3093634)
Acronym LARGE [Returns the nth largest element from a data set, where n is user-defined](https://support.google.com/docs/answer/3094008)
Acronym LCM [Returns the least common multiple of one or more integers](https://support.google.com/docs/answer/3093421)
Acronym LEFT [Returns a substring from the beginning of a specified string](https://support.google.com/docs/answer/3094079)
Acronym LN [Returns the the logarithm of a number, base e (Euler's number)](https://support.google.com/docs/answer/3093422)
Acronym LOG [Returns the the logarithm of a number given a base](https://support.google.com/docs/answer/3093495)
Acronym LOGINV [Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value](https://support.google.com/docs/answer/3094010)
Acronym LOGNORM.DIST Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. [Learn More](https://www.google.com/docs/answer/3094010)
Acronym LOGNORM.INV Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value. [Learn More](https://www.google.com/docs/answer/3094010)
Acronym LOGNORMDIST [Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value](https://support.google.com/docs/answer/3094011)
Acronym LOOKUP [Looks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column](https://support.google.com/docs/answer/3256570)
Acronym LT [Returns TRUE if the first argument is strictly less than the second, and FALSE otherwise. Equivalent to the < operator](https://support.google.com/docs/answer/3093596)
Acronym LTE [Returns TRUE if the first argument is less than or equal to the second, and FALSE otherwise. Equivalent to the <= operator](https://support.google.com/docs/answer/3093976)
Acronym MATCH [Returns the relative position of an item in a range that matches a specified value](https://support.google.com/docs/answer/3093378)
Acronym MAXIFS [Returns the maximum value in a range of cells, filtered by a set of criteria.](https://support.google.com/docs/answer/7013817)
Acronym MDETERM [Returns the matrix determinant of a square matrix specified as an array or range](https://support.google.com/docs/answer/3094290)
Acronym MDURATION [Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield](https://support.google.com/docs/answer/3093178)
Acronym MIDB Returns a section of a string starting at a given character and up to a specified number of bytes. [Learn More](https://www.google.com/docs/answer/9367691)
Acronym MINIFS [Returns the minimum value in a range of cells, filtered by a set of criteria.](https://support.google.com/docs/answer/7014063)
Acronym MINUS [Returns the difference of two numbers. Equivalent to the - operator](https://support.google.com/docs/answer/3093977)
Acronym MINUTE [Returns the minute component of a specific time, in numeric format](https://support.google.com/docs/answer/3093048)
Acronym MINVERSE [Returns the multiplicative inverse of a square matrix specified as an array or range](https://support.google.com/docs/answer/3094253)
Acronym MIRR [Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income](https://support.google.com/docs/answer/3093180)
Acronym MMULT [Calculates the matrix product of two matrices specified as arrays or ranges](https://support.google.com/docs/answer/3094292)
Acronym MOD [Returns the result of the modulo operator, the remainder after a division operation](https://support.google.com/docs/answer/3093497)
Acronym MONTH [Returns the month of the year a specific date falls in, in numeric format](https://support.google.com/docs/answer/3093052)
Acronym MROUND [Rounds one number to the nearest integer multiple of another](https://support.google.com/docs/answer/3093426)
Acronym MULTINOMIAL [Returns the factorial of the sum of values divided by the product of the values' factorials](https://support.google.com/docs/answer/3093429)
Acronym MULTIPLY [Returns the product of two numbers. Equivalent to the * operator](https://support.google.com/docs/answer/3093978)
Acronym NA [Returns the "value not available" error, #N/A](https://support.google.com/docs/answer/3093359)
Acronym NE [Returns TRUE if two specified values are not equal and FALSE otherwise. Equivalent to the != operator](https://support.google.com/docs/answer/3093981)
Acronym NEGBINOM.DIST Returns TRUE if two specified values are not equal and FALSE otherwise. Equivalent to the <> operator. [Learn More](https://www.google.com/docs/answer/3093981)
Acronym NEGBINOMDIST [Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials](https://support.google.com/docs/answer/3094031)
Acronym NETWORKDAYS [Returns the number of net working days between two provided days](https://support.google.com/docs/answer/3092979)
Acronym NETWORKDAYS.INTL [Returns the number of net working days between two provided days excluding specified weekend days and holidays](https://support.google.com/docs/answer/3295902)
Acronym NOMINAL [Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year](https://support.google.com/docs/answer/3093234)
Acronym NORMDIST [Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation](https://support.google.com/docs/answer/3094021)
Acronym NORMINV [Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation](https://support.google.com/docs/answer/3094022)
Acronym NORMSDIST [Returns the value of the standard normal cumulative distribution function for a specified value](https://support.google.com/docs/answer/3094089)
Acronym NORMSINV [Returns the value of the inverse standard normal distribution function for a specified value](https://support.google.com/docs/answer/3094091)
Acronym NOT [Returns the opposite of a logical value - NOT(TRUE) returns FALSE; NOT(FALSE) returns TRUE](https://support.google.com/docs/answer/3093305)
Acronym NOW [Returns the current date and time as a date value](https://support.google.com/docs/answer/3092981)
Acronym NPER [Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093183)
Acronym NPV [Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate](https://support.google.com/docs/answer/3093184)
Acronym OFFSET [Returns a range reference shifted a specified number of rows and columns from a starting cell reference](https://support.google.com/docs/answer/3093379)
Acronym OR [Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false](https://support.google.com/docs/answer/3093306)
Acronym PEARSON [Calculates r, the Pearson product-moment correlation coefficient of a dataset](https://support.google.com/docs/answer/3094092)
Acronym PERCENTILE [Returns the value at a given percentile of a dataset](https://support.google.com/docs/answer/3094093)
Acronym PERCENTRANK [Returns the percentage rank (percentile) of a specified value in a dataset](https://support.google.com/docs/answer/3094095)
Acronym PERCENTRANK.EXC [Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.](https://support.google.com/docs/answer/3267357)
Acronym PERCENTRANK.INC [Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset](https://support.google.com/docs/answer/3267360)
Acronym PERMUT [Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order](https://support.google.com/docs/answer/3094036)
Acronym PERMUTATIONA Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects. [Learn more](https://support.google.com/docs/answer/9368324)
Acronym PHI [Returns the value of the normal distribution with mean 0 and standard deviation 1.](https://support.google.com)
Acronym PMT [Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093185)
Acronym POISSON [Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean](https://support.google.com/docs/answer/3094097)
Acronym POISSON.DIST [Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.](https://support.google.com)
Acronym PPMT [Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093187)
Acronym PRICE [Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield](https://support.google.com/docs/answer/3093188)
Acronym PRICEDISC [Calculates the price of a discount (non-interest-bearing) security, based on expected yield](https://support.google.com/docs/answer/3093240)
Acronym PRICEMAT [Calculates the price of a security paying interest at maturity, based on expected yield](https://support.google.com/docs/answer/3093191)
Acronym PROB [Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits](https://support.google.com/docs/answer/3094039)
Acronym PRODUCT [Returns the result of multiplying a series of numbers together](https://support.google.com/docs/answer/3093502)
Acronym PV [Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate](https://support.google.com/docs/answer/3093243)
Acronym QUARTILE [Returns a value nearest to a specified quartile of a dataset](https://support.google.com/docs/answer/3094041)
Acronym RAND [Returns a random number between 0 inclusive and 1 exclusive](https://support.google.com/docs/answer/3093438)
Acronym RANK [Returns the rank of a specified value in a dataset](https://support.google.com/docs/answer/3094098)
Acronym RANK.AVG [Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the average rank of the entries will be returned](https://support.google.com/docs/answer/3267309)
Acronym RANK.EQ [Returns the rank of a specified value in a dataset. If there is more than one entry of the same value in the dataset, the top rank of the entries will be returned](https://support.google.com/docs/answer/3267310)
Acronym RATE [Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate](https://support.google.com/docs/answer/3093257)
Acronym REGEXREPLACE [Replaces part of a text string with a different text string using regular expressions](https://support.google.com/docs/answer/3098245)
Acronym REPLACE [Replaces part of a text string with a different text string](https://support.google.com/docs/answer/3098247)
Acronym RIGHT [Returns a substring from the end of a specified string](https://support.google.com/docs/answer/3094087)
Acronym ROUND [Rounds a number to a certain number of decimal places according to standard rules](https://support.google.com/docs/answer/3093440)
Acronym ROUNDDOWN [Rounds a number to a certain number of decimal places, always rounding down to the next valid increment](https://support.google.com/docs/answer/3093442)
Acronym ROUNDUP [Rounds a number to a certain number of decimal places, always rounding up to the next valid increment](https://support.google.com/docs/answer/3093443)
Acronym ROWS [Returns the number of rows in a specified array or range](https://support.google.com/docs/answer/3093382)
Acronym RRI Returns the interest rate needed for an investment to reach a specific value within a given number of periods. [Learn more](https://support.google.com/docs/answer/9368238)
Acronym RSQ [Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset](https://support.google.com/docs/answer/3094099)
Acronym SEARCH [Returns the position at which a string is first found within text](https://support.google.com/docs/answer/3094154)
Acronym SEARCHB [Returns the position at which a string is first found within text counting each double-character as 2](https://support.google.com/docs/answer/3295923)
Acronym SECH [The SECH function returns the hyperbolic secant of an angle](https://support.google.com/docs/answer/9116560)
Acronym SECOND [Returns the second component of a specific time, in numeric format](https://support.google.com/docs/answer/3093054)
Acronym SERIESSUM [Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)m), where i is the number of entries in range a](https://support.google.com/docs/answer/3093444)
Acronym SIGN [Given an input number, returns -1 if it is negative, 1 if positive, and 0 if it is zero](https://support.google.com/docs/answer/3093513)
Acronym SKEW [Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean](https://support.google.com/docs/answer/3094101)
Acronym SLN [Calculates the depreciation of an asset for one period using the straight-line method](https://support.google.com/docs/answer/3093245)
Acronym SLOPE [Calculates the slope of the line resulting from linear regression of a dataset](https://support.google.com/docs/answer/3094048)
Acronym SMALL [Returns the nth smallest element from a data set, where n is user-defined](https://support.google.com/docs/answer/3094050)
Acronym SORT [Sorts the rows of a given array or range by the values in one or more columns](https://support.google.com/docs/answer/3093150)
Acronym SORTN [Returns the first n items in a data set after performing a sort](https://support.google.com/docs/answer/7354624)
Acronym SPLIT [Divides text around a specified character or string, and puts each fragment into a separate cell in the row](https://support.google.com/docs/answer/3094136)
Acronym SQRTPI [Returns the positive square root of the product of Pi and the given positive number](https://support.google.com/docs/answer/3093579)
Acronym STANDARDIZE [Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution](https://support.google.com/docs/answer/3094102)
Acronym STDEVA [Calculates the standard deviation based on a sample, setting text to the value 0](https://support.google.com/docs/answer/3094055)
Acronym STDEVPA [Calculates the standard deviation based on an entire population, setting text to the value 0](https://support.google.com/docs/answer/3094058)
Acronym STEYX [Calculates the standard error of the predicted y-value for each x in the regression of a dataset](https://support.google.com/docs/answer/3094108)
Acronym SUBTOTAL [Returns a subtotal for a vertical range of cells using a specified aggregation function](https://support.google.com/docs/answer/3093649)
Acronym SUM [Returns the sum of a series of numbers and/or cells](https://support.google.com/docs/answer/3093669)
Acronym SUMIFS [Returns the sum of a range depending on multiple criteria](https://support.google.com/docs/answer/3238496)
Acronym SUMPRODUCT [Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges](https://support.google.com/docs/answer/3094294)
Acronym SUMSQ [Returns the sum of the squares of a series of numbers and/or cells](https://support.google.com/docs/answer/3093714)
Acronym SUMX2MY2 [Calculates the sum of the differences of the squares of values in two arrays](https://support.google.com/docs/answer/3094257)
Acronym SUMX2PY2 [Calculates the sum of the sums of the squares of values in two arrays](https://support.google.com/docs/answer/3094260)
Acronym SUMXMY2 [Calculates the sum of the squares of differences of values in two arrays](https://support.google.com/docs/answer/3094298)
Acronym SWITCH [Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is met](https://support.google.com/docs/answer/7013690)
Acronym SYD [Calculates the depreciation of an asset for a specified period using the sum of years digits method](https://support.google.com/docs/answer/3093261)
Acronym T.TEST [t-test. Returns the probability associated with Student's t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean.](https://support.google.com)
Acronym TBILLEQ [Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate](https://support.google.com/docs/answer/3093249)
Acronym TBILLPRICE [Calculates the price of a US Treasury Bill based on discount rate](https://support.google.com/docs/answer/3093251)
Acronym TBILLYIELD [Calculates the yield of a US Treasury Bill based on price](https://support.google.com/docs/answer/3093264)
Acronym TDIST [Calculates the probability for Student's t-distribution with a given input (x)](https://support.google.com/docs/answer/3295914)
Acronym TEXT [Converts a number into text according to a specified format](https://support.google.com/docs/answer/3094139)
Acronym TEXTJOIN [Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.](https://support.google.com/docs/answer/7013992)
Acronym TIME [Converts a provided hour, minute, and second into a time](https://support.google.com/docs/answer/3093056)
Acronym TIMEVALUE [Returns the fraction of a 24-hour day the time represents](https://support.google.com/docs/answer/3267350)
Acronym TO_PURE_NUMBER [Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting](https://support.google.com/docs/answer/3094243)
Acronym TRANSPOSE [Transposes the rows and columns of an array or range of cells](https://support.google.com/docs/answer/3094262)
Acronym TREND [Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values](https://support.google.com/docs/answer/3094263)
Acronym TRIMMEAN [Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset](https://support.google.com/docs/answer/3094061)
Acronym TRUE [Returns the logical value TRUE](https://support.google.com/docs/answer/3093307)
Acronym TRUNC [Truncates a number to a certain number of significant digits by omitting less significant digits](https://support.google.com/docs/answer/3093588)
Acronym TTEST [Returns the probability associated with t-test. Determines whether two samples are likely to have come from the same two underlying populations that have the same mean](https://support.google.com/docs/answer/6055837)
Acronym TYPE [Returns a number associated with the type of data passed into the function](https://support.google.com/docs/answer/3267375)
Acronym UNARY_PERCENT [Returns a value interpreted as a percentage; that is, UNARY_PERCENT(100) equals 1](https://support.google.com/docs/answer/3093982)
Acronym UNICODE [Returns the decimal Unicode value of the first character of the text.](https://support.google.com/docs/answer/9149523)
Acronym UNIQUE [Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range](https://support.google.com/docs/answer/3093198)
Acronym VALUE [Converts a string in any of the date, time or number formats that Google Sheets understands into a number](https://support.google.com/docs/answer/3094220)
Acronym VARA [Calculates an estimate of variance based on a sample, setting text to the value 0.](https://support.google.com/docs/answer/3094064)
Acronym VARPA [Calculates the variance based on an entire population, setting text to the value 0](https://support.google.com/docs/answer/3094065)
Acronym VDB [Returns the depreciation of an asset for a particular period (or partial period).](https://support.google.com)
Acronym VLOOKUP [Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found](https://support.google.com/docs/answer/3093318)
Acronym WEEKDAY [Returns a number representing the day of the week of the date provided](https://support.google.com/docs/answer/3092985)
Acronym WEEKNUM [Returns a number representing the week of the year where the provided date falls](https://support.google.com/docs/answer/3294949)
Acronym WEIBULL [Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale](https://support.google.com/docs/answer/3094116)
Acronym WEIBULL.DIST Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale. [Learn More](https://www.google.com/docs/answer/3094116)
Acronym WORKDAY [Calculates the number of working days from a specified start date](https://support.google.com/docs/answer/3093059)
Acronym WORKDAY.INTL [Calculates the date after a specified number of workdays excluding specified weekend days and holidays](https://support.google.com/docs/answer/3294972)
Acronym XIRR [Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows](https://support.google.com/docs/answer/3093266)
Acronym XNPV [Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate](https://support.google.com/docs/answer/3093268)