SheetFX
≡
  • ABS: Returns the absolute value of a number.
  • ACCRINT: Calculates the accrued interest of a security that has periodic payments.
  • ACCRINTM: Calculates the accrued interest of a security that pays interest at maturity.
  • ACOS: Returns the inverse cosine of a value, in radians.
  • ACOSH: Returns the inverse hyperbolic cosine of a number.
  • ACOT: Returns the inverse cotangent of a value, in radians.
  • ACOTH: Returns the inverse hyperbolic cotangent of a value, in radians. Must not be between -1 and 1, inclusive.
  • ADD: Returns the sum of two numbers. Equivalent to the `+` operator.
  • ADDRESS: Returns a cell reference as a string.
  • AMORLINC: Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period.
  • AND: Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false.
  • ARABIC: Computes the value of a Roman numeral.
  • ARRAY_CONSTRAIN: Constrains an array result to a specified size.
  • 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.
  • ASC: Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged.
  • ASIN: Returns the inverse sine of a value, in radians.
  • ASINH: Returns the inverse hyperbolic sine of a number.
  • ATAN: Returns the inverse tangent of a value, in radians.
  • 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.
  • ATANH: Returns the inverse hyperbolic tangent of a number.
  • AVEDEV: Calculates the average of the magnitudes of deviations of data from a dataset's mean.
  • AVERAGE: Returns the numerical average value in a dataset, ignoring text.
  • AVERAGE.WEIGHTED: Finds the weighted average of a set of values, given the values and the corresponding weights.
  • AVERAGEA: Returns the numerical average value in a dataset.
  • AVERAGEIF: Returns the average of a range depending on criteria.
  • AVERAGEIFS: Returns the average of a range depending on multiple criteria.
  • BASE: Converts a number into a text representation in another base, for example, base 2 for binary.
  • BETA.DIST: Returns the probability of a given value as defined by the beta distribution function.
  • BETA.INV: Returns the value of the inverse beta distribution function for a given probability.
  • BETADIST: See BETA.DIST.
  • BETAINV: See BETA.INV
  • BIN2DEC: Converts a signed binary number to decimal format.
  • BIN2HEX: Converts a signed binary number to signed hexadecimal format.
  • BIN2OCT: Converts a signed binary number to signed octal format.
  • BINOM.DIST: See BINOMDIST
  • BINOM.INV: See CRITBINOM
  • 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.
  • BITAND: Bitwise boolean AND of two numbers.
  • BITLSHIFT: Shifts the bits of the input a certain number of places to the left.
  • BITOR: Bitwise boolean OR of 2 numbers.
  • BITRSHIFT: Shifts the bits of the input a certain number of places to the right.
  • BITXOR: Bitwise XOR (exclusive OR) of 2 numbers.
  • BYCOL: Groups an array by columns by application of a LAMBDA function to each column.
  • BYROW: Groups an array by rows by application of a LAMBDA function to each row.
  • CEILING: Rounds a number up to the nearest integer multiple of specified significance.
  • 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.
  • 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.
  • CELL: Returns the requested information about the specified cell.
  • CHAR: Convert a number into a character according to the current Unicode table.
  • CHIDIST: Calculates the right-tailed chi-squared distribution, often used in hypothesis testing.
  • CHIINV: Calculates the inverse of the right-tailed chi-squared distribution.
  • CHISQ.DIST: Calculates the left-tailed chi-squared distribution, often used in hypothesis testing.
  • CHISQ.DIST.RT: Calculates the right-tailed chi-squared distribution, which is commonly used in hypothesis testing.
  • CHISQ.INV: Calculates the inverse of the left-tailed chi-squared distribution.
  • CHISQ.INV.RT: Calculates the inverse of the right-tailed chi-squared distribution.
  • CHISQ.TEST: See CHITEST
  • 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.
  • CHOOSE: Returns an element from a list of choices based on index.
  • CHOOSECOLS: Creates a new array from the selected columns in the existing range.
  • CHOOSEROWS: Creates a new array from the selected rows in the existing range.
  • CLEAN: Returns the text with the non-printable ASCII characters removed.
  • CODE: Returns the numeric Unicode map value of the first character in the string provided.
  • COLUMN: Returns the column number of a specified cell, with `A=1`.
  • COLUMNS: Returns the number of columns in a specified array or range.
  • COMBIN: Returns the number of ways to choose some number of objects from a pool of a given size of objects.
  • 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.
  • COMPLEX: Creates a complex number given real and imaginary coefficients.
  • CONCAT: Returns the concatenation of two values. Equivalent to the `&` operator.
  • CONCATENATE: Appends strings to one another.
  • CONFIDENCE: See CONFIDENCE.NORM
  • CONFIDENCE.NORM: Calculates the width of half the confidence interval for a normal distribution.
  • CONFIDENCE.T: Calculates the width of half the confidence interval for a Student’s t-distribution.
  • CONVERT: Converts a numeric value to a different unit of measure.
  • CORREL: Calculates r, the Pearson product-moment correlation coefficient of a dataset.
  • COS: Returns the cosine of an angle provided in radians.
  • COSH: Returns the hyperbolic cosine of any real number.
  • COT: Cotangent of an angle provided in radians.
  • COTH: Returns the hyperbolic cotangent of any real number.
  • COUNT: Returns a count of the number of numeric values in a dataset.
  • COUNTA: Returns a count of the number of values in a dataset.
  • COUNTBLANK: Returns the number of empty cells in a given range.
  • COUNTIF: Returns a conditional count across a range.
  • COUNTIFS: Returns the count of a range depending on multiple criteria.
  • COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.
  • COUPDAYBS: Calculates the number of days from the first coupon, or interest payment, until settlement.
  • COUPDAYS: Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date.
  • COUPDAYSNC: Calculates the number of days from the settlement date until the next coupon, or interest payment.
  • COUPNCD: Calculates next coupon, or interest payment, date after the settlement date.
  • COUPNUM: Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment.
  • COUPPCD: Calculates last coupon, or interest payment, date before the settlement date.
  • COVAR: Calculates the covariance of a dataset.
  • COVARIANCE.P: See COVAR
  • COVARIANCE.S: Calculates the covariance of a dataset, where the dataset is a sample of the total population.
  • CRITBINOM: Calculates the smallest value for which the cumulative binomial distribution is greater than or equal to a specified criteria.
  • CSC: Returns the cosecant of an angle provided in radians.
  • CSCH: The CSCH function returns the hyperbolic cosecant of any real number.
  • 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.
  • 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.
  • DATE: Converts a provided year, month, and day into a date.
  • DATEDIF: Calculates the number of days, months, or years between two dates.
  • DATEVALUE: Converts a provided date string in a known format to a date value.
  • DAVERAGE: Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.
  • DAY: Returns the day of the month that a specific date falls on, in numeric format.
  • DAYS: Returns the number of days between two dates.
  • DAYS360: Returns the difference between two days based on the 360 day year used in some financial interest calculations.
  • DB: Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
  • DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.
  • DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.
  • DDB: Calculates the depreciation of an asset for a specified period using the double-declining balance method.
  • DEC2BIN: Converts a decimal number to signed binary format.
  • DEC2HEX: Converts a decimal number to signed hexadecimal format.
  • DEC2OCT: Converts a decimal number to signed octal format.
  • DECIMAL: The DECIMAL function converts the text representation of a number in another base, to base 10 (decimal).
  • DEGREES: Converts an angle value in radians to degrees.
  • DELTA: Compare two numeric values, returning 1 if they're equal.
  • DETECTLANGUAGE: Identifies the language used in text within the specified range.
  • DEVSQ: Calculates the sum of squares of deviations based on a sample.
  • DGET: Returns a single value from a database table-like array or range using a SQL-like query.
  • DISC: Calculates the discount rate of a security based on price.
  • DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.
  • DMAX: Returns the maximum value selected from a database table-like array or range using a SQL-like query.
  • DMIN: Returns the minimum value selected from a database table-like array or range using a SQL-like query.
  • DOLLAR: Formats a number into the locale-specific currency format.
  • DOLLARDE: Converts a price quotation given as a decimal fraction into a decimal value.
  • DOLLARFR: Converts a price quotation given as a decimal value into a decimal fraction.
  • DPRODUCT: Returns the product of values selected from a database table-like array or range using a SQL-like query.
  • DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.
  • DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.
  • DSUM: Returns the sum of values selected from a database table-like array or range using a SQL-like query.
  • 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.
  • DVAR: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.
  • DVARP: Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.
  • EDATE: Returns a date a specified number of months before or after another date.
  • EFFECT: Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
  • ENCODEURL: Encodes a string of text for the purpose of using in a URL query.
  • EOMONTH: Returns a date representing the last day of a month which falls a specified number of months before or after another date.
  • EPOCHTODATE: Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.
  • EQ: Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
  • ERF: The ERF function returns the integral of the Gauss error function over an interval of values.
  • ERF.PRECISE: See ERF
  • ERFC: Returns the complementary Gauss error function of a value.
  • ERFC.PRECISE: See ERFC
  • ERROR.TYPE: Returns a number corresponding to the error value in a different cell.
  • EVEN: Rounds a number up to the nearest even integer.
  • EXACT: Tests whether two strings are identical.
  • EXP: Returns Euler's number, e (~2.718) raised to a power.
  • EXPON.DIST: Returns the value of the exponential distribution function with a specified LAMBDA at a specified value.
  • EXPONDIST: See EXPON.DIST
  • 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.
  • 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.
  • F.INV: Calculates the inverse of the left-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
  • F.INV.RT: Calculates the inverse of the right-tailed F probability distribution. Also called the Fisher-Snedecor distribution or Snedecor’s F distribution.
  • F.TEST: See FTEST.
  • FACT: Returns the factorial of a number.
  • FACTDOUBLE: Returns the "double factorial" of a number.
  • FALSE: Returns the logical value `FALSE`.
  • FDIST: See F.DIST.RT.
  • FILTER: Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
  • FIND: Returns the position at which a string is first found within text.
  • FINDB: Returns the position at which a string is first found within text counting each double-character as 2.
  • FINV: See F.INV.RT
  • FISHER: Returns the Fisher transformation of a specified value.
  • FISHERINV: Returns the inverse Fisher transformation of a specified value.
  • FIXED: Formats a number with a fixed number of decimal places.
  • FLATTEN: Flattens all the values from one or more ranges into a single column.
  • FLOOR: Rounds a number down to the nearest integer multiple of specified significance.
  • 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.
  • FLOOR.PRECISE: The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.
  • FORECAST: Calculates the expected y-value for a specified x based on a linear regression of a dataset.
  • FORECAST.LINEAR: See FORECAST
  • FORMULATEXT: Returns the formula as a string.
  • FREQUENCY: Calculates the frequency distribution of a one-column array into specified classes.
  • 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.
  • FV: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
  • FVSCHEDULE: Calculates the future value of some principal based on a specified series of potentially varying interest rates.
  • GAMMA: Returns the Gamma function evaluated at the specified value.
  • GAMMA.DIST: Calculates the gamma distribution, a two-parameter continuous probability distribution.
  • GAMMA.INV: The GAMMA.INV function returns the value of the inverse gamma cumulative distribution function for the specified probability and alpha and beta parameters.
  • GAMMADIST: See GAMMA.DIST
  • GAMMAINV: See GAMMA.INV.
  • GAMMALN: Returns the the logarithm of a specified Gamma function, base e (Euler's number).
  • GAMMALN.PRECISE: See GAMMALN
  • GAUSS: The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between the mean and z standard deviations above (or below) the mean.
  • GCD: Returns the greatest common divisor of one or more integers.
  • GEOMEAN: Calculates the geometric mean of a dataset.
  • 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.
  • GETPIVOTDATA: Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
  • GOOGLEFINANCE: Fetches current or historical securities information from Google Finance.
  • GOOGLETRANSLATE: Translates text from one language into another Learn more
  • GROWTH: Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.
  • GT: Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the `>` operator.
  • GTE: Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent to the `>=` operator.
  • HARMEAN: Calculates the harmonic mean of a dataset.
  • HEX2BIN: Converts a signed hexadecimal number to signed binary format.
  • HEX2DEC: Converts a signed hexadecimal number to decimal format.
  • HEX2OCT: Converts a signed hexadecimal number to signed octal format.
  • 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.
  • HOUR: Returns the hour component of a specific time, in numeric format.
  • HSTACK: Appends ranges horizontally and in sequence to return a larger array.
  • HYPERLINK: Creates a hyperlink inside a cell.
  • HYPGEOM.DIST: See HYPGEOMDIST
  • 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.
  • IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`.
  • 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.
  • IFNA: Evaluates a value. If the value is an #N/A error, returns the specified value.
  • IFS: Evaluates multiple conditions and returns a value that corresponds to the first true condition.
  • IMABS: Returns absolute value of a complex number.
  • IMAGE: Inserts an image into a cell.
  • IMAGINARY: Returns the imaginary coefficient of a complex number.
  • IMARGUMENT: The IMARGUMENT function returns the angle (also known as the argument or \theta) of the given complex number in radians.
  • IMCONJUGATE: Returns the complex conjugate of a number.
  • IMCOS: The IMCOS function returns the cosine of the given complex number.
  • IMCOSH: Returns the hyperbolic cosine of the given complex number. For example, a given complex number "x+yi" returns "cosh(x+yi)." Learn more.
  • IMCOT: Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)." Learn more.
  • IMCOTH: Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)." Learn more.
  • IMCSC: Returns the cosecant of the given complex number.
  • IMCSCH: Returns the hyperbolic cosecant of the given complex number. For example, a given complex number "x+yi" returns "csch(x+yi)." Learn more.
  • IMDIV: Returns one complex number divided by another.
  • IMEXP: Returns Euler's number, e (~2.718) raised to a complex power.
  • IMLN: Returns the logarithm of a complex number, base e (Euler's number).
  • IMLOG: Returns the logarithm of a complex number for a specified base.
  • IMLOG10: Returns the logarithm of a complex number with base 10.
  • IMLOG2: Returns the logarithm of a complex number with base 2.
  • IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
  • IMPORTFEED: Imports a RSS or ATOM feed.
  • IMPORTHTML: Imports data from a table or list within an HTML page.
  • IMPORTRANGE: Imports a range of cells from a specified spreadsheet.
  • IMPORTXML: Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
  • IMPOWER: Returns a complex number raised to a power.
  • IMPRODUCT: Returns the result of multiplying a series of complex numbers together.
  • IMREAL: Returns the real coefficient of a complex number.
  • IMSEC: Returns the secant of the given complex number. For example, a given complex number "x+yi" returns "sec(x+yi)." Learn more.
  • IMSECH: Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)." Learn more.
  • IMSIN: Returns the sine of the given complex number.
  • IMSINH: Returns the hyperbolic sine of the given complex number. For example, a given complex number "x+yi" returns "sinh(x+yi)." Learn more.
  • IMSQRT: Computes the square root of a complex number.
  • IMSUB: Returns the difference between two complex numbers.
  • IMSUM: Returns the sum of a series of complex numbers.
  • IMTAN: Returns the tangent of the given complex number.
  • IMTANH: Returns the hyperbolic tangent of the given complex number. For example, a given complex number "x+yi" returns "tanh(x+yi)." Learn more.
  • INDEX: Returns the content of a cell, specified by row and column offset.
  • INDIRECT: Returns a cell reference specified by a string.
  • INT: Rounds a number down to the nearest integer that is less than or equal to it.
  • INTERCEPT: Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis (x=0).
  • 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.
  • IPMT: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.
  • IRR: Calculates the internal rate of return on an investment based on a series of periodic cash flows.
  • ISBETWEEN: Checks whether a provided number is between two other numbers either inclusively or exclusively.
  • ISBLANK: Checks whether the referenced cell is empty.
  • ISDATE: Returns whether a value is a date.
  • ISEMAIL: Checks whether a value is a valid email address.
  • ISERR: Checks whether a value is an error other than `#N/A`.
  • ISERROR: Checks whether a value is an error.
  • ISEVEN: Checks whether the provided value is even.
  • ISFORMULA: Checks whether a formula is in the referenced cell.
  • ISLOGICAL: Checks whether a value is `TRUE` or `FALSE`.
  • ISNA: Checks whether a value is the error `#N/A`.
  • ISNONTEXT: Checks whether a value is non-textual.
  • ISNUMBER: Checks whether a value is a number.
  • ISO.CEILING: See CEILING.PRECISE
  • ISODD: Checks whether the provided value is odd.
  • ISOWEEKNUM: Returns the number of the ISO week of the year where the provided date falls.
  • ISPMT: The ISPMT function calculates the interest paid during a particular period of an investment.
  • ISREF: Checks whether a value is a valid cell reference.
  • ISTEXT: Checks whether a value is text.
  • ISURL: Checks whether a value is a valid URL.
  • JOIN: Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
  • KURT: Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.
  • LAMBDA: Creates and returns a custom function with a set of names and a formula_expression that uses them. To calculate the formula_expression, you can call the returned function with as many values as the name declares.
  • LARGE: Returns the nth largest element from a data set, where n is user-defined.
  • LCM: Returns the least common multiple of one or more integers.
  • LEFT: Returns a substring from the beginning of a specified string.
  • LEFTB: Returns the left portion of a string up to a certain number of bytes.
  • LEN: Returns the length of a string.
  • LENB: Returns the length of a string in bytes." Learn more.
  • LET: Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the names defined in the scope of the LET function. The value_expressions are evaluated only once in the LET function even if the following value_expressions or the formula_expression use them multiple times.
  • LINEST: Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares method.
  • LN: Returns the the logarithm of a number, base e (Euler's number).
  • LOG: Returns the the logarithm of a number given a base.
  • LOG10: Returns the the logarithm of a number, base 10.
  • LOGEST: Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.
  • LOGINV: Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified value.
  • LOGNORM.DIST: See LOGNORMDIST
  • LOGNORM.INV: See LOGINV
  • LOGNORMDIST: Returns the value of the log-normal cumulative distribution with given mean and standard deviation at a specified value.
  • 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.
  • LOWER: Converts a specified string to lowercase.
  • LT: Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the `<` operator.
  • LTE: Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent to the `<=` operator.
  • MAKEARRAY: Returns an array of specified dimensions with values calculated by application of a LAMBDA function.
  • MAP: Maps each value in the given arrays to a new value by application of a LAMBDA function to each value.
  • MARGINOFERROR: Calculates the amount of random sampling error given a range of values and a confidence level.
  • MATCH: Returns the relative position of an item in a range that matches a specified value.
  • MAX: Returns the maximum value in a numeric dataset.
  • MAXA: Returns the maximum numeric value in a dataset.
  • MAXIFS: Returns the maximum value in a range of cells, filtered by a set of criteria.
  • MDETERM: Returns the matrix determinant of a square matrix specified as an array or range.
  • MDURATION: Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
  • MEDIAN: Returns the median value in a numeric dataset.
  • MID: Returns a segment of a string.
  • MIDB: Returns a section of a string starting at a given character and up to a specified number of bytes.
  • MIN: Returns the minimum value in a numeric dataset.
  • MINA: Returns the minimum numeric value in a dataset.
  • MINIFS: Returns the minimum value in a range of cells, filtered by a set of criteria.
  • MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.
  • MINUTE: Returns the minute component of a specific time, in numeric format.
  • MINVERSE: Returns the multiplicative inverse of a square matrix specified as an array or range.
  • 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.
  • MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.
  • MOD: Returns the result of the modulo operator, the remainder after a division operation.
  • MODE: Returns the most commonly occurring value in a dataset.
  • MODE.MULT: Returns the most commonly occurring values in a dataset.
  • MODE.SNGL: See MODE
  • MONTH: Returns the month of the year a specific date falls in, in numeric format.
  • MROUND: Rounds one number to the nearest integer multiple of another.
  • MULTINOMIAL: Returns the factorial of the sum of values divided by the product of the values' factorials.
  • MULTIPLY: Returns the product of two numbers. Equivalent to the `*` operator.
  • MUNIT: Returns a unit matrix of size dimension x dimension.
  • N: Returns the argument provided as a number.
  • NA: Returns the "value not available" error, `#N/A`.
  • NE: Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
  • NEGBINOM.DIST: See NEGBINOMDIST
  • 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.
  • NETWORKDAYS: Returns the number of net working days between two provided days.
  • NETWORKDAYS.INTL: Returns the number of net working days between two provided days excluding specified weekend days and holidays.
  • NOMINAL: Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
  • NORM.DIST: See NORMDIST
  • NORM.INV: See NORMINV
  • NORM.S.DIST: See NORMSDIST
  • NORM.S.INV: See NORMSINV
  • NORMDIST: Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
  • NORMINV: Returns the value of the inverse normal distribution function for a specified value, mean, and standard deviation.
  • NORMSDIST: Returns the value of the standard normal cumulative distribution function for a specified value.
  • NORMSINV: Returns the value of the inverse standard normal distribution function for a specified value.
  • NOT: Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
  • NOW: Returns the current date and time as a date value.
  • NPER: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.
  • NPV: Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate.
  • OCT2BIN: Converts a signed octal number to signed binary format.
  • OCT2DEC: Converts a signed octal number to decimal format.
  • OCT2HEX: Converts a signed octal number to signed hexadecimal format.
  • ODD: Rounds a number up to the nearest odd integer.
  • OFFSET: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.
  • OR: Returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false.
  • PDURATION: Returns the number of periods for an investment to reach a specific value at a given rate.
  • PEARSON: Calculates r, the Pearson product-moment correlation coefficient of a dataset.
  • PERCENTILE: Returns the value at a given percentile of a dataset.
  • PERCENTILE.EXC: Returns the value at a given percentile of a dataset, exclusive of 0 and 1.
  • PERCENTILE.INC: See PERCENTILE
  • PERCENTRANK: Returns the percentage rank (percentile) of a specified value in a dataset.
  • PERCENTRANK.EXC: Returns the percentage rank (percentile) from 0 to 1 exclusive of a specified value in a dataset.
  • PERCENTRANK.INC: Returns the percentage rank (percentile) from 0 to 1 inclusive of a specified value in a dataset.
  • PERMUT: Returns the number of ways to choose some number of objects from a pool of a given size of objects, considering order.
  • PERMUTATIONA: Returns the number of permutations for selecting a group of objects (with replacement) from a total number of objects.
  • PHI: The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.
  • PI: Returns the value of Pi to 14 decimal places.
  • PMT: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
  • POISSON: See POISSON.DIST
  • POISSON.DIST: Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and mean.
  • POW: Returns a number raised to a power.
  • POWER: Returns a number raised to a power.
  • PPMT: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.
  • PRICE: Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield.
  • PRICEDISC: Calculates the price of a discount (non-interest-bearing) security, based on expected yield.
  • PRICEMAT: Calculates the price of a security paying interest at maturity, based on expected yield.
  • PROB: Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls between two limits.
  • PRODUCT: Returns the result of multiplying a series of numbers together.
  • PROPER: Capitalizes each word in a specified string.
  • PV: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
  • QUARTILE: Returns a value nearest to a specified quartile of a dataset.
  • QUARTILE.EXC: Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4.
  • QUARTILE.INC: See QUARTILE
  • QUERY: Runs a Google Visualization API Query Language query across data.
  • QUOTIENT: Returns one number divided by another.
  • RADIANS: Converts an angle value in degrees to radians.
  • RAND: Returns a random number between 0 inclusive and 1 exclusive.
  • RANDARRAY: Generates an array of random numbers between 0 and 1.
  • RANDBETWEEN: Returns a uniformly random integer between two values, inclusive.
  • RANK: Returns the rank of a specified value in a dataset.
  • 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.
  • 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.
  • RATE: Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate.
  • RECEIVED: Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.
  • REDUCE: Reduces an array to an accumulated result by application of a LAMBDA function to each value.
  • REGEXEXTRACT: Extracts matching substrings according to a regular expression.
  • REGEXMATCH: Whether a piece of text matches a regular expression.
  • REGEXREPLACE: Replaces part of a text string with a different text string using regular expressions.
  • REPLACE: Replaces part of a text string with a different text string.
  • REPLACEB: Replaces part of a text string, based on a number of bytes, with a different text string.
  • REPT: Returns specified text repeated a number of times.
  • RIGHT: Returns a substring from the end of a specified string.
  • RIGHTB: Returns the right portion of a string up to a certain number of bytes.
  • ROMAN: Formats a number in Roman numerals.
  • ROUND: Rounds a number to a certain number of decimal places according to standard rules.
  • ROUNDDOWN: Rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
  • ROUNDUP: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
  • ROW: Returns the row number of a specified cell.
  • ROWS: Returns the number of rows in a specified array or range.
  • RRI: Returns the interest rate needed for an investment to reach a specific value within a given number of periods.
  • RSQ: Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
  • SCAN: Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.
  • SEARCH: Returns the position at which a string is first found within text.
  • SEARCHB: Returns the position at which a string is first found within text counting each double-character as 2.
  • SEC: The SEC function returns the secant of an angle, measured in radians.
  • SECH: The SECH function returns the hyperbolic secant of an angle.
  • SECOND: Returns the second component of a specific time, in numeric format.
  • SEQUENCE: Returns an array of sequential numbers, such as 1, 2, 3, 4.
  • 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`.
  • SIGN: Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
  • SIN: Returns the sine of an angle provided in radians.
  • SINH: Returns the hyperbolic sine of any real number.
  • SKEW: Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
  • SKEW.P: Calculates the skewness of a dataset that represents the entire population.
  • SLN: Calculates the depreciation of an asset for one period using the straight-line method.
  • SLOPE: Calculates the slope of the line resulting from linear regression of a dataset.
  • SMALL: Returns the nth smallest element from a data set, where n is user-defined.
  • SORT: Sorts the rows of a given array or range by the values in one or more columns.
  • SORTN: Returns the first n items in a data set after performing a sort.
  • SPARKLINE: Creates a miniature chart contained within a single cell.
  • SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row.
  • SQRT: Returns the positive square root of a positive number.
  • SQRTPI: Returns the positive square root of the product of Pi and the given positive number.
  • STANDARDIZE: Calculates the normalized equivalent of a random variable given mean and standard deviation of the distribution.
  • STDEV: Calculates the standard deviation based on a sample.
  • STDEV.P: See STDEVP
  • STDEV.S: See STDEV
  • STDEVA: Calculates the standard deviation based on a sample, setting text to the value `0`.
  • STDEVP: Calculates the standard deviation based on an entire population.
  • STDEVPA: Calculates the standard deviation based on an entire population, setting text to the value `0`.
  • STEYX: Calculates the standard error of the predicted y-value for each x in the regression of a dataset.
  • SUBSTITUTE: Replaces existing text with new text in a string.
  • SUBTOTAL: Returns a subtotal for a vertical range of cells using a specified aggregation function.
  • SUM: Returns the sum of a series of numbers and/or cells.
  • SUMIF: Returns a conditional sum across a range.
  • SUMIFS: Returns the sum of a range depending on multiple criteria.
  • SUMPRODUCT: Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
  • SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.
  • SUMX2MY2: Calculates the sum of the differences of the squares of values in two arrays.
  • SUMX2PY2: Calculates the sum of the sums of the squares of values in two arrays.
  • SUMXMY2: Calculates the sum of the squares of differences of values in two arrays.
  • 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.
  • SYD: Calculates the depreciation of an asset for a specified period using the sum of years digits method.
  • T: Returns string arguments as text.
  • T.DIST: Returns the right tailed Student distribution for a value x.
  • T.DIST.2T: Returns the two tailed Student distribution for a value x.
  • T.DIST.RT: Returns the right tailed Student distribution for a value x.
  • T.INV: Calculates the negative inverse of the one-tailed TDIST function.
  • T.INV.2T: Calculates the inverse of the two-tailed TDIST function.
  • 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.
  • TAN: Returns the tangent of an angle provided in radians.
  • TANH: Returns the hyperbolic tangent of any real number.
  • TBILLEQ: Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
  • TBILLPRICE: Calculates the price of a US Treasury Bill based on discount rate.
  • TBILLYIELD: Calculates the yield of a US Treasury Bill based on price.
  • TDIST: Calculates the probability for Student's t-distribution with a given input (x).
  • TEXT: Converts a number into text according to a specified format.
  • TEXTJOIN: Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating the different texts.
  • TIME: Converts a provided hour, minute, and second into a time.
  • TIMEVALUE: Returns the fraction of a 24-hour day the time represents.
  • TINV: See T.INV.2T
  • TO_DATE: Converts a provided number to a date.
  • TO_DOLLARS: Converts a provided number to a dollar value.
  • TO_PERCENT: Converts a provided number to a percentage.
  • TO_PURE_NUMBER: Converts a provided date/time, percentage, currency or other formatted numeric value to a pure number without formatting.
  • TO_TEXT: Converts a provided numeric value to a text value.
  • TOCOL: Transforms an array or range of cells into a single column.
  • TODAY: Returns the current date as a date value.
  • TOROW: Transforms an array or range of cells into a single row.
  • TRANSPOSE: Transposes the rows and columns of an array or range of cells.
  • TREND: Given partial data about a linear trend, fits an ideal linear trend using the least squares method and/or predicts further values.
  • TRIM: Removes leading and trailing spaces in a specified string.
  • TRIMMEAN: Calculates the mean of a dataset excluding some proportion of data from the high and low ends of the dataset.
  • TRUE: Returns the logical value `TRUE`.
  • TRUNC: Truncates a number to a certain number of significant digits by omitting less significant digits.
  • TTEST: See T.TEST.
  • TYPE: Returns a number associated with the type of data passed into the function.
  • UMINUS: Returns a number with the sign reversed.
  • UNARY_PERCENT: Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
  • UNICHAR: Returns the Unicode character for a number.
  • UNICODE: Returns the decimal Unicode value of the first character of the text.
  • 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.
  • 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.
  • UPLUS: Returns a specified number, unchanged.
  • UPPER: Converts a specified string to uppercase.
  • VALUE: Converts a string in any of the date, time or number formats that Google Sheets understands into a number.
  • VAR: Calculates the variance based on a sample.
  • VAR.P: See VARP
  • VAR.S: See VAR
  • VARA: Calculates an estimate of variance based on a sample, setting text to the value `0`.
  • VARP: Calculates the variance based on an entire population.
  • VARPA: Calculates the variance based on an entire population, setting text to the value `0`.
  • VDB: Returns the depreciation of an asset for a particular period (or partial period).
  • 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.
  • VSTACK: Appends ranges vertically and in sequence to return a larger array.
  • WEEKDAY: Returns a number representing the day of the week of the date provided.
  • WEEKNUM: Returns a number representing the week of the year where the provided date falls.
  • WEIBULL: Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and scale.
  • WEIBULL.DIST: See WEIBULL
  • WORKDAY: Calculates the end date after a specified number of working days.
  • WORKDAY.INTL: Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
  • WRAPCOLS: Wraps the provided row or column of cells by columns after a specified number of elements to form a new array.
  • WRAPROWS: Wraps the provided row or column of cells by rows after a specified number of elements to form a new array.
  • XIRR: Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows.
  • XLOOKUP: Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.
  • XNPV: Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate.
  • XOR: The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are different, and a 0 otherwise.
  • YEAR: Returns the year specified by a given date.
  • YEARFRAC: Returns the number of years, including fractional years, between two dates using a specified day count convention.
  • YIELD: Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price.
  • YIELDDISC: Calculates the annual yield of a discount (non-interest-bearing) security, based on price.
  • YIELDMAT: Calculates the annual yield of a security paying interest at maturity, based on price.
  • Z.TEST: Returns the one-tailed P-value of a Z-test with standard distribution.
  • ZTEST: See Z.TEST.