TypeFewer LettersMore Letters
Acronym ABS [Returns the absolute value of a number](https://support.google.com/docs/answer/3093459)
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 ACOS [Returns the inverse cosine of a value, in radians](https://support.google.com/docs/answer/3093461)
Acronym ACOSH [Returns the inverse hyperbolic cosine of a number](https://support.google.com/docs/answer/3093391)
Acronym ADD [Returns the sum of two numbers. Equivalent to the `+` operator](https://support.google.com/docs/answer/3093590)
Acronym ADDRESS [Returns a cell reference as a string](https://support.google.com/docs/answer/3093308)
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 ARABIC [Computes the value of a Roman numeral](https://support.google.com/docs/answer/3238301)
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 ARRAY_CONSTRAIN [Constrains an array result to a specified size](https://support.google.com/docs/answer/3267036)
Acronym ASIN [Returns the inverse sine of a value, in radians](https://support.google.com/docs/answer/3093464)
Acronym ASINH [Returns the inverse hyperbolic sine of a number](https://support.google.com/docs/answer/3093393)
Acronym ATAN [Returns the inverse tangent of a value, in radians](https://support.google.com/docs/answer/3093395)
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 ATANH [Returns the inverse hyperbolic tangent of a number](https://support.google.com/docs/answer/3093397)
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 AVERAGEA [Returns the numerical average value in a dataset](https://support.google.com/docs/answer/3093617)
Acronym AVERAGEIF [Returns the average of a range depending on criteria](https://support.google.com/docs/answer/3256529)
Acronym AVERAGEIFS [Returns the average of a range depending on multiple criteria](https://support.google.com/docs/answer/3256534)
Acronym BASE64 A custom function by /u/16495701722. [Link](https://www.reddit.com/r/googlesheets/wiki/custom_functions#wiki_base64.28.29)
Acronym BIN2DEC [Converts a signed binary number to decimal format](https://support.google.com/docs/answer/3092991)
Acronym BIN2HEX [Converts a signed binary number to signed hexadecimal format](https://support.google.com/docs/answer/3093133)
Acronym BIN2OCT [Converts a signed binary number to signed octal format](https://support.google.com/docs/answer/3092993)
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 CEILING [Rounds a number up to the nearest integer multiple of specified significance](https://support.google.com/docs/answer/3093471)
Acronym CELL [Returns the requested information about the specified cell](https://support.google.com/docs/answer/3267071)
Acronym CHAR [Convert a number into a character according to the current Unicode table](https://support.google.com/docs/answer/3094120)
Acronym CHOOSE [Returns an element from a list of choices based on index](https://support.google.com/docs/answer/3093371)
Acronym CLEAN [Returns the text with the non-printable ASCII characters removed](https://support.google.com/docs/answer/3267340)
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 CONCAT [Returns the concatenation of two values. Equivalent to the `&` operator](https://support.google.com/docs/answer/3093592)
Acronym CONCATENATE [Appends strings to one another](https://support.google.com/docs/answer/3094123)
Acronym CONFIDENCE [Calculates the width of half the confidence interval for a normal distribution](https://support.google.com/docs/answer/3093988)
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 COS [Returns the cosine of an angle provided in radians](https://support.google.com/docs/answer/3093476)
Acronym COSH [Returns the hyperbolic cosine of any real number](https://support.google.com/docs/answer/3093477)
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 COUNTIF [Returns a conditional count across a range](https://support.google.com/docs/answer/3093480)
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 COVAR [Calculates the covariance of a dataset](https://support.google.com/docs/answer/3093993)
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 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 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 DEC2BIN [Converts a decimal number to signed binary format](https://support.google.com/docs/answer/3092997)
Acronym DEC2HEX [Converts a decimal number to signed hexadecimal format](https://support.google.com/docs/answer/3093137)
Acronym DEC2OCT [Converts a decimal number to signed octal format](https://support.google.com/docs/answer/3093138)
Acronym DEGREES [Converts an angle value in radians to degrees](https://support.google.com/docs/answer/3093481)
Acronym DELTA [Compare two numeric values, returning 1 if they're equal](https://support.google.com/docs/answer/3401147)
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 DOLLAR [Formats a number into the locale-specific currency format](https://support.google.com/docs/answer/3094071)
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 ERFC [Returns the complementary Gauss error function of a value](https://support.google.com/docs/answer/3093407)
Acronym ERROR.TYPE [Returns a number corresponding to the error value in a different cell](https://support.google.com/docs/answer/3238305)
Acronym EVEN [Rounds a number up to the nearest even integer](https://support.google.com/docs/answer/3093409)
Acronym EXACT [Tests whether two strings are identical](https://support.google.com/docs/answer/3094073)
Acronym EXP [Returns Euler's number, e (~2.718) raised to a power](https://support.google.com/docs/answer/3093411)
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 FACT [Returns the factorial of a number](https://support.google.com/docs/answer/3093412)
Acronym FACTDOUBLE [Returns the "double factorial" of a number](https://support.google.com/docs/answer/3093414)
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 FISHER [Returns the Fisher transformation of a specified value](https://support.google.com/docs/answer/3093626)
Acronym FISHERINV [Returns the inverse Fisher transformation of a specified value](https://support.google.com/docs/answer/3093998)
Acronym FIXED [Formats a number with a fixed number of decimal places](https://support.google.com/docs/answer/3094075)
Acronym FLOOR [Rounds a number down to the nearest integer multiple of specified significance](https://support.google.com/docs/answer/3093487)
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 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 GAMMALN [Returns the the logarithm of a specified Gamma function, base e (Euler's number)](https://support.google.com/docs/answer/3093416)
Acronym GCD [Returns the greatest common divisor of one or more integers](https://support.google.com/docs/answer/3093489)
Acronym GEOMEAN [Calculates the geometric mean of a dataset](https://support.google.com/docs/answer/3094001)
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 GOOGLEFINANCE [Fetches current or historical securities information from Google Finance](https://support.google.com/docs/answer/3093281)
Acronym GOOGLETRANSLATE [Translates text from one language into another/ Learn more](https://support.google.com/docs/answer/3093331)
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 HARMEAN [Calculates the harmonic mean of a dataset](https://support.google.com/docs/answer/3094003)
Acronym HEX2BIN [Converts a signed hexadecimal number to signed binary format](https://support.google.com/docs/answer/3093139)
Acronym HEX2DEC [Converts a signed hexadecimal number to decimal format](https://support.google.com/docs/answer/3093192)
Acronym HEX2OCT [Converts a signed hexadecimal number to signed octal format](https://support.google.com/docs/answer/3093142)
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 HYPERLINK [Creates a hyperlink inside a cell](https://support.google.com/docs/answer/3093313)
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 IMAGE [Inserts an image into a cell](https://support.google.com/docs/answer/3093333)
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 IMPORTFEED [Imports a RSS or ATOM feed](https://support.google.com/docs/answer/3093337)
Acronym IMPORTHTML [Imports data from a table or list within an HTML page](https://support.google.com/docs/answer/3093339)
Acronym IMPORTRANGE [Imports a range of cells from a specified spreadsheet](https://support.google.com/docs/answer/3093340)
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 INDEX [Returns the content of a cell, specified by row and column offset](https://support.google.com/docs/answer/3098242)
Acronym INDIRECT [Returns a cell reference specified by a string](https://support.google.com/docs/answer/3093377)
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 ISBLANK [Checks whether the referenced cell is empty](https://support.google.com/docs/answer/3093290)
Acronym ISEMAIL [Checks whether a value is a valid email address](https://support.google.com/docs/answer/3256503)
Acronym ISERR [Checks whether a value is an error other than `#N/A`](https://support.google.com/docs/answer/3093348)
Acronym ISERROR [Checks whether a value is an error](https://support.google.com/docs/answer/3093349)
Acronym ISEVEN [Checks whether the provided value is even](https://support.google.com/docs/answer/3093419)
Acronym ISFORMULA [Checks whether a formula is in the referenced cell](https://support.google.com/docs/answer/6270316)
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 ISNONTEXT [Checks whether a value is non-textual](https://support.google.com/docs/answer/3093295)
Acronym ISNUMBER [Checks whether a value is a number](https://support.google.com/docs/answer/3093296)
Acronym ISODD [Checks whether the provided value is odd](https://support.google.com/docs/answer/3093491)
Acronym ISREF [Checks whether a value is a valid cell reference](https://support.google.com/docs/answer/3093354)
Acronym ISTEXT [Checks whether a value is text](https://support.google.com/docs/answer/3093297)
Acronym ISURL [Checks whether a value is a valid URL](https://support.google.com/docs/answer/3256501)
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 LEN [Returns the length of a string](https://support.google.com/docs/answer/3094081)
Acronym LINEST [Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method](https://support.google.com/docs/answer/3094249)
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 LOG10 [Returns the the logarithm of a number, base 10](https://support.google.com/docs/answer/3093423)
Acronym LOGEST [Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve](https://support.google.com/docs/answer/3094251)
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 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 LOWER [Converts a specified string to lowercase](https://support.google.com/docs/answer/3094083)
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 MAX [Returns the maximum value in a numeric dataset](https://support.google.com/docs/answer/3094013)
Acronym MAXA [Returns the maximum numeric value in a dataset](https://support.google.com/docs/answer/3094016)
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 MEDIAN [Returns the median value in a numeric dataset](https://support.google.com/docs/answer/3094025)
Acronym MID [Returns a segment of a string](https://support.google.com/docs/answer/3094129)
Acronym MIN [Returns the minimum value in a numeric dataset](https://support.google.com/docs/answer/3094017)
Acronym MINA [Returns the minimum numeric value in a dataset](https://support.google.com/docs/answer/3094018)
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 MODE [Returns the most commonly occurring value in a dataset](https://support.google.com/docs/answer/3094029)
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 N [Returns the argument provided as a number](https://support.google.com/docs/answer/3093357)
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 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 OCT2BIN [Converts a signed octal number to signed binary format](https://support.google.com/docs/answer/3093144)
Acronym OCT2DEC [Converts a signed octal number to decimal format](https://support.google.com/docs/answer/3093146)
Acronym OCT2HEX [Converts a signed octal number to signed hexadecimal format](https://support.google.com/docs/answer/3093147)
Acronym ODD [Rounds a number up to the nearest odd integer](https://support.google.com/docs/answer/3093499)
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. Learn more](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 PI [Returns the value of Pi to 14 decimal places](https://support.google.com/docs/answer/3093432)
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 POW [Returns a number raised to a power](https://support.google.com/docs/answer/3093603)
Acronym POWER [Returns a number raised to a power](https://support.google.com/docs/answer/3093433)
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 PROPER [Capitalizes each word in a specified string](https://support.google.com/docs/answer/3094133)
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 QUERY [Runs a Google Visualization API Query Language query across data](https://support.google.com/docs/answer/3093343)
Acronym QUOTIENT [Returns one number divided by another](https://support.google.com/docs/answer/3093436)
Acronym RADIANS [Converts an angle value in degrees to radians](https://support.google.com/docs/answer/3093437)
Acronym RAND [Returns a random number between 0 inclusive and 1 exclusive](https://support.google.com/docs/answer/3093438)
Acronym RANDBETWEEN [Returns a uniformly random integer between two values, inclusive](https://support.google.com/docs/answer/3093507)
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 RECEIVED [Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date](https://support.google.com/docs/answer/3093244)
Acronym REGEXEXTRACT [Extracts matching substrings according to a regular expression](https://support.google.com/docs/answer/3098244)
Acronym REGEXMATCH [Whether a piece of text matches a regular expression](https://support.google.com/docs/answer/3098292)
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 REPT [Returns specified text repeated a number of times](https://support.google.com/docs/answer/3094134)
Acronym RIGHT [Returns a substring from the end of a specified string](https://support.google.com/docs/answer/3094087)
Acronym ROMAN [Formats a number in Roman numerals](https://support.google.com/docs/answer/3094153)
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 ROW [Returns the row number of a specified cell](https://support.google.com/docs/answer/3093316)
Acronym ROWS [Returns the number of rows in a specified array or range](https://support.google.com/docs/answer/3093382)
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 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 SIN [Returns the sine of an angle provided in radians](https://support.google.com/docs/answer/3093447)
Acronym SINH [Returns the hyperbolic sine of any real number](https://support.google.com/docs/answer/3093517)
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 SPARKLINE [Creates a miniature chart contained within a single cell](https://support.google.com/docs/answer/3093289)
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 SQRT [Returns the positive square root of a positive number](https://support.google.com/docs/answer/3093577)
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 STDEV [Calculates the standard deviation based on a sample](https://support.google.com/docs/answer/3094054)
Acronym STDEVA [Calculates the standard deviation based on a sample, setting text to the value `0`](https://support.google.com/docs/answer/3094055)
Acronym STDEVP [Calculates the standard deviation based on an entire population](https://support.google.com/docs/answer/3094105)
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 SUBSTITUTE [Replaces existing text with new text in a string](https://support.google.com/docs/answer/3094215)
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 SUMIF [Returns a conditional sum across a range](https://support.google.com/docs/answer/3093583)
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 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 [Returns string arguments as text](https://support.google.com/docs/answer/3094138)
Acronym T.INV [Calculates the negative inverse of the one-tailed TDIST function](https://support.google.com/docs/answer/6055809)
Acronym T.INV.2T [Calculates the inverse of the two-tailed TDIST function](https://support.google.com/docs/answer/6055811)
Acronym TAN [Returns the tangent of an angle provided in radians](https://support.google.com/docs/answer/3093586)
Acronym TANH [Returns the hyperbolic tangent of any real number](https://support.google.com/docs/answer/3093755)
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 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 TINV [Calculates the inverse of the two-tailed TDIST function](https://support.google.com/docs/answer/6055791)
Acronym TODAY [Returns the current date as a date value](https://support.google.com/docs/answer/3092984)
Acronym TO_DATE [Converts a provided number to a date](https://support.google.com/docs/answer/3094239)
Acronym TO_DOLLARS [Converts a provided number to a dollar value](https://support.google.com/docs/answer/3094241)
Acronym TO_PERCENT [Converts a provided number to a percentage](https://support.google.com/docs/answer/3094284)
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 TO_TEXT [Converts a provided numeric value to a text value](https://support.google.com/docs/answer/3094285)
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 TRIM [Removes leading and trailing spaces in a specified string](https://support.google.com/docs/answer/3094140)
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 UMINUS [Returns a number with the sign reversed](https://support.google.com/docs/answer/3093606)
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 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 UPLUS [Returns a specified number, unchanged.](https://support.google.com/docs/answer/3093608)
Acronym UPPER [Converts a specified string to uppercase](https://support.google.com/docs/answer/3094219)
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 VAR [Calculates the variance based on a sample](https://support.google.com/docs/answer/3094063)
Acronym VARA [Calculates an estimate of variance based on a sample, setting text to the value `0`. Learn more](https://support.google.com/docs/answer/3094064)
Acronym VARP [Calculates the variance based on an entire population](https://support.google.com/docs/answer/3094113)
Acronym VARPA [Calculates the variance based on an entire population, setting text to the value `0`](https://support.google.com/docs/answer/3094065)
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 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)
Acronym YEAR [Returns the year specified by a given date](https://support.google.com/docs/answer/3093061)
Acronym YEARFRAC [Returns the number of years, including fractional years, between two dates using a specified day count convention](https://support.google.com/docs/answer/3092989)
Acronym YIELD [Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price](https://support.google.com/docs/answer/3093255)
Acronym YIELDDISC [Calculates the annual yield of a discount (non-interest-bearing) security, based on price](https://support.google.com/docs/answer/3093270)
Acronym ZTEST [Returns the two-tailed P-value of a Z-test with standard distribution](https://support.google.com/docs/answer/3094067)