The index
All Google Sheets formulas
Every formula covered on Sheet Formulas, grouped by category. Tap any one to jump straight to its tutorial.
Array · 29
- ARRAY_CONSTRAIN Constrains an array result to a specified size.
- 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.
- 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.
- FLATTEN Flattens all the values from one or more ranges into a single column.
- FREQUENCY Calculates the frequency distribution of a one-column array into specified classes.
- GROWTH Given partial data about an exponential growth trend, fits an ideal exponential growth trend and/or predicts further values.
- HSTACK Appends ranges horizontally and in sequence to return a larger array.
- LINEST Given partial data about a linear trend, calculates various parameters about the ideal linear trend using the least-squares…
- LOGEST Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth…
- 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…
- MDETERM Returns the matrix determinant of a square matrix specified as an array or range.
- MINVERSE Returns the multiplicative inverse of a square matrix specified as an array or range.
- MMULT Calculates the matrix product of two matrices specified as arrays or ranges.
- REDUCE Reduces an array to an accumulated result by application of a LAMBDA function to each value.
- SCAN Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an…
- SUMPRODUCT Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
- 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.
- TOCOL Transforms an array or range of cells into a single column.
- 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…
- VSTACK Appends ranges vertically and in sequence to return a larger array.
- WRAPCOLS Wraps the provided row or column of cells by columns after a specified number of elements to form…
- WRAPROWS Wraps the provided row or column of cells by rows after a specified number of elements to form…
Database · 12
- DAVERAGE Returns the average of a set of values selected from a database table-like array or range using a…
- 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.
- DGET Returns a single value from a database table-like array or range using a SQL-like query.
- 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.
- 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…
- DSTDEVP Returns the standard deviation of an entire population selected from a database table-like array or range using a…
- DSUM Returns the sum of values selected from a database table-like array or range using a SQL-like query.
- DVAR Returns the variance of a population sample selected from a database table-like array or range using a SQL-like…
- DVARP Returns the variance of an entire population selected from a database table-like array or range using a SQL-like…
Date · 25
- 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.
- 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. Learn more.
- DAYS360 Returns the difference between two days based on the 360 day year used in some financial interest calculations.
- EDATE Returns a date a specified number of months before or after another date.
- EOMONTH Returns a date representing the last day of a month which falls a specified number of months before…
- HOUR Returns the hour component of a specific time, in numeric format.
- ISOWEEKNUM Returns the number of the ISO week of the year where the provided date falls.
- MINUTE Returns the minute component of a specific time, in numeric format.
- MONTH Returns the month of the year a specific date falls in, in numeric format.
- 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.
- NOW Returns the current date and time as a date value.
- SECOND Returns the second component of a specific time, in numeric format.
- TIME Converts a provided hour, minute, and second into a time.
- TIMEVALUE Returns the fraction of a 24-hour day the time represents.
- TODAY Returns the current date as a date value.
- 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.
- 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.
- 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.
Engineering · 47
- 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.
- BITAND Bitwise boolean AND of two numbers. Learn more.
- BITLSHIFT Shifts the bits of the input a certain number of places to the left. Learn more.
- BITOR Bitwise boolean OR of 2 numbers. Learn more.
- BITRSHIFT Shifts the bits of the input a certain number of places to the right. Learn more.
- BITXOR Bitwise XOR (exclusive OR) of 2 numbers. Learn more.
- COMPLEX Creates a complex number given real and imaginary coefficients.
- 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.
- DELTA Compare two numeric values, returning 1 if they're equal.
- ERF The ERF function returns the integral of the Gauss error function over an interval of values.
- ERF.PRECISE See ERF
- GESTEP Returns 1 if the rate is strictly greater than or equal to the provided step value or 0…
- 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.
- IMABS Returns absolute value of a complex number.
- 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…
- 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)."
- IMCOT Returns the cotangent of the given complex number. For example, a given complex number "x+yi" returns "cot(x+yi)."
- IMCOTH Returns the hyperbolic cotangent of the given complex number. For example, a given complex number "x+yi" returns "coth(x+yi)."
- 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)."
- IMDIV Returns one complex number divided by another.
- IMEXP Returns Euler's number, e (~2.718) raised to a complex power.
- 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.
- 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)."
- IMSECH Returns the hyperbolic secant of the given complex number. For example, a given complex number "x+yi" returns "sech(x+yi)."
- 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)."
- 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)."
- 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.
Filter · 4
- FILTER Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.
- 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.
- UNIQUE Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which…
Financial · 49
- 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.
- AMORLINC Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the…
- 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…
- COUPPCD Calculates last coupon, or interest payment, date before the settlement date.
- CUMIPMT Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments…
- CUMPRINC Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic…
- DB Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method.
- DDB Calculates the depreciation of an asset for a specified period using the double-declining balance method.
- DISC Calculates the discount rate of a security based on price.
- 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.
- EFFECT Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.
- 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.
- INTRATE Calculates the effective interest rate generated when an investment is purchased at one price and sold at another…
- 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.
- ISPMT The ISPMT function calculates the interest paid during a particular period of an investment.
- MDURATION Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based…
- MIRR Calculates the modified internal rate of return on an investment based on a series of periodic cash flows…
- NOMINAL Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
- NPER Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest…
- NPV Calculates the net present value of an investment based on a series of periodic cash flows and a…
- PDURATION Returns the number of periods for an investment to reach a specific value at a given rate.
- PMT Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.
- PPMT Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest…
- PRICE Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected…
- 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.
- PV Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.
- RATE Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a…
- RECEIVED Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date.
- RRI Returns the interest rate needed for an investment to reach a specific value within a given number of…
- SLN Calculates the depreciation of an asset for one period using the straight-line method.
- SYD Calculates the depreciation of an asset for a specified period using the sum of years digits method.
- 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.
- VDB Returns the depreciation of an asset for a particular period (or partial period).
- XIRR Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced…
- XNPV Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash…
- YIELD Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on…
- 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.
Google · 7
- ARRAYFORMULA Enables the display of values returned from an array formula into multiple rows and/or columns and the use…
- DETECTLANGUAGE Identifies the language used in text within the specified range.
- GOOGLEFINANCE Fetches current or historical securities information from Google Finance.
- GOOGLETRANSLATE Translates text from one language into another
- IMAGE Inserts an image into a cell.
- QUERY Runs a Google Visualization API Query Language query across data.
- SPARKLINE Creates a miniature chart contained within a single cell.
Info · 18
- CELL Returns the requested information about the specified cell.
- ERROR.TYPE Returns a number corresponding to the error value in a different cell.
- ISBLANK Checks whether the referenced cell is empty.
- ISDATE Returns whether a value is a date. Learn more.
- 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.
- 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.
- ISREF Checks whether a value is a valid cell reference.
- ISTEXT Checks whether a value is text.
- N Returns the argument provided as a number.
- NA Returns the "value not available" error, `#N/A`.
- SHEETS Returns the total number of sheets in the referenced spreadsheet. Learn more about the SHEETS function.
- TYPE Returns a number associated with the type of data passed into the function.
Logical · 13
- AND Returns true if all of the provided arguments are logically true, and false if any of the provided…
- FALSE Returns the logical value `FALSE`.
- 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,…
- 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.
- LAMBDA Creates and returns a custom function with a set of names and a formula_expression that uses them. To…
- LET Assigns name with the value_expression results and returns the result of the formula_expression. The formula_expression can use the…
- NOT Returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE`.
- OR Returns true if any of the provided arguments are logically true, and false if all of the provided…
- SWITCH Tests an expression against a list of cases and returns the corresponding value of the first matching case,…
- TRUE Returns the logical value `TRUE`.
- XOR The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are…
Lookup · 17
- ADDRESS Returns a cell reference as a string.
- CHOOSE Returns an element from a list of choices based on index.
- COLUMN Returns the column number of a specified cell, with `A=1`.
- COLUMNS Returns the number of columns in a specified array or range.
- FORMULATEXT Returns the formula as a string.
- GETPIVOTDATA Extracts an aggregated value from a pivot table that corresponds to the specified row and column headings.
- HLOOKUP Horizontal lookup. Searches across the first row of a range for a key and returns the value of…
- INDEX Returns the content of a cell, specified by row and column offset.
- INDIRECT Returns a cell reference specified by a string.
- LOOKUP Looks through a row or column for a key and returns the value of the cell in a…
- MATCH Returns the relative position of an item in a range that matches a specified value.
- OFFSET Returns a range reference shifted a specified number of rows and columns from a starting cell reference.
- ROW Returns the row number of a specified cell.
- ROWS Returns the number of rows in a specified array or range.
- SHEET Returns the sheet number of the specified sheet or other reference. Learn more about the SHEET function.
- VLOOKUP Vertical lookup. Searches down the first column of a range for a key and returns the value of…
- XLOOKUP Returns the values in the result range based on the position where a match was found in the…
Math · 84
- ABS Returns the absolute value of a number.
- 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.
- 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…
- ATANH Returns the inverse hyperbolic tangent of a number.
- BASE Converts a number into a text representation in another base, for example, base 2 for binary.
- 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…
- CEILING.PRECISE Rounds a number up to the nearest integer multiple of specified significance. If the number is positive or…
- COMBIN Returns the number of ways to choose some number of objects from a pool of a given size…
- COMBINA Returns the number of ways to choose some number of objects from a pool of a given size…
- 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.
- 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.
- CSC Returns the cosecant of an angle provided in radians.
- CSCH The CSCH function returns the hyperbolic cosecant of any real number.
- 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.
- ERFC Returns the complementary Gauss error function of a value.
- ERFC.PRECISE See ERFC
- EVEN Rounds a number up to the nearest even integer.
- EXP Returns Euler's number, e (~2.718) raised to a power.
- FACT Returns the factorial of a number.
- FACTDOUBLE Returns the "double factorial" of a number.
- 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…
- FLOOR.PRECISE The FLOOR.PRECISE function rounds a number down to the nearest integer or multiple of specified significance.
- GAMMALN Returns the the logarithm of a specified Gamma function, base e (Euler's number).
- GAMMALN.PRECISE See GAMMALN
- GCD Returns the greatest common divisor of one or more integers.
- IMLN Returns the logarithm of a complex number, base e (Euler's number).
- IMPOWER Returns a complex number raised to a power.
- IMSQRT Computes the square root of a complex number.
- INT Rounds a number down to the nearest integer that is less than or equal to it.
- ISEVEN Checks whether the provided value is even.
- ISO.CEILING See CEILING.PRECISE
- ISODD Checks whether the provided value is odd.
- LCM Returns the least common multiple of one or more integers.
- 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.
- MOD Returns the result of the modulo operator, the remainder after a division operation.
- 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.
- MUNIT Returns a unit matrix of size dimension x dimension.
- ODD Rounds a number up to the nearest odd integer.
- PI Returns the value of Pi to 14 decimal places.
- POWER Returns a number raised to a power.
- PRODUCT Returns the result of multiplying a series of numbers together.
- 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.
- 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.
- SEC The SEC function returns the secant of an angle, measured in radians.
- SECH The SECH function returns the hyperbolic secant of an angle.
- 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) + ... +…
- SIGN Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is…
- SIN Returns the sine of an angle provided in radians.
- SINH Returns the hyperbolic sine of any real number.
- 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.
- 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.
- SUMSQ Returns the sum of the squares of a series of numbers and/or cells.
- TAN Returns the tangent of an angle provided in radians.
- TANH Returns the hyperbolic tangent of any real number.
- TRUNC Truncates a number to a certain number of significant digits by omitting less significant digits.
Operator · 16
- ADD Returns the sum of two numbers. Equivalent to the `+` operator.
- CONCAT Returns the concatenation of two values. Equivalent to the `&` operator.
- DIVIDE Returns one number divided by another. Equivalent to the `/` operator.
- EQ Returns `TRUE` if two specified values are equal and `FALSE` otherwise. Equivalent to the `=` operator.
- GT Returns `TRUE` if the first argument is strictly greater than the second, and `FALSE` otherwise. Equivalent to the…
- GTE Returns `TRUE` if the first argument is greater than or equal to the second, and `FALSE` otherwise. Equivalent…
- ISBETWEEN Checks whether a provided number is between two other numbers either inclusively or exclusively.
- LT Returns `TRUE` if the first argument is strictly less than the second, and `FALSE` otherwise. Equivalent to the…
- LTE Returns `TRUE` if the first argument is less than or equal to the second, and `FALSE` otherwise. Equivalent…
- MINUS Returns the difference of two numbers. Equivalent to the `-` operator.
- MULTIPLY Returns the product of two numbers. Equivalent to the `*` operator.
- NE Returns `TRUE` if two specified values are not equal and `FALSE` otherwise. Equivalent to the `<>` operator.
- POW Returns a number raised to a power.
- UMINUS Returns a number with the sign reversed.
- UNARY_PERCENT Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.
- UPLUS Returns a specified number, unchanged.
Parser · 6
- CONVERT Converts a numeric value to a different unit of measure.
- 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.
Statistical · 136
- 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.
- 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. Learn more.
- BETADIST See BETA.DIST.
- BETAINV See BETA.INV
- 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…
- 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…
- 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.
- CORREL Calculates r, the Pearson product-moment correlation coefficient of a dataset.
- 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.
- 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…
- DEVSQ Calculates the sum of squares of deviations based on a sample.
- EXPON.DIST Returns the value of the exponential distribution function with a specified LAMBDA at a specified value. Learn more.
- 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…
- F.DIST.RT Calculates the right-tailed F probability distribution (degree of diversity) for two data sets with given input x. Alternately…
- 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.
- FDIST See F.DIST.RT.
- FINV See F.INV.RT
- FISHER Returns the Fisher transformation of a specified value.
- FISHERINV Returns the inverse Fisher transformation of a specified value.
- FORECAST Calculates the expected y-value for a specified x based on a linear regression of a dataset.
- FORECAST.LINEAR See FORECAST
- FTEST Returns the probability associated with an F-test for equality of variances. Determines whether two samples are likely to…
- 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…
- GAMMADIST See GAMMA.DIST
- GAMMAINV See GAMMA.INV.
- GAUSS The GAUSS function returns the probability that a random variable, drawn from a normal distribution, will be between…
- GEOMEAN Calculates the geometric mean of a dataset.
- HARMEAN Calculates the harmonic mean of a dataset.
- HYPGEOM.DIST See HYPGEOMDIST
- HYPGEOMDIST Calculates the probability of drawing a certain number of successes in a certain number of tries given a…
- INTERCEPT Calculates the y-value at which the line resulting from linear regression of a dataset will intersect the y-axis…
- KURT Calculates the kurtosis of a dataset, which describes the shape, and in particular the "peakedness" of that dataset.
- LARGE Returns the nth largest element from a data set, where n is user-defined.
- LOGINV Returns the value of the inverse log-normal cumulative distribution with given mean and standard deviation at a specified…
- 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.
- MARGINOFERROR Calculates the amount of random sampling error given a range of values and a confidence level.
- 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.
- MEDIAN Returns the median value in a numeric dataset.
- 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.
- 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
- NEGBINOM.DIST See NEGBINOMDIST
- NEGBINOMDIST Calculates the probability of drawing a certain number of failures before a certain number of successes given a…
- 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,…
- 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.
- 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…
- PERMUTATIONA Returns the number of permutations for selecting a group of objects (with replacement) from a total number of…
- PHI The PHI function returns the value of the normal distribution with mean 0 and standard deviation 1.
- POISSON See POISSON.DIST
- POISSON.DIST Returns the value of the Poisson distribution function (or Poisson cumulative distribution function) for a specified value and…
- PROB Given a set of values and corresponding probabilities, calculates the probability that a value chosen at random falls…
- 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
- 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…
- RANK.EQ Returns the rank of a specified value in a dataset. If there is more than one entry of…
- RSQ Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
- 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.
- 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.
- 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.
- 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…
- TDIST Calculates the probability for Student's t-distribution with a given input (x).
- TINV See T.INV.2T
- TRIMMEAN Calculates the mean of a dataset excluding some proportion of data from the high and low ends of…
- TTEST See T.TEST.
- 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`.
- WEIBULL Returns the value of the Weibull distribution function (or Weibull cumulative distribution function) for a specified shape and…
- WEIBULL.DIST See WEIBULL
- Z.TEST Returns the one-tailed P-value of a Z-test with standard distribution. Learn more.
- ZTEST See Z.TEST.
Text · 41
- ARABIC Computes the value of a Roman numeral.
- ASC Converts full-width ASCII and katakana characters to their half-width counterparts. All standard-width characters will remain unchanged. Learn more.
- CHAR Convert a number into a character according to the current Unicode table.
- 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.
- CONCATENATE Appends strings to one another.
- DOLLAR Formats a number into the locale-specific currency format.
- EXACT Tests whether two strings are identical.
- 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.
- FIXED Formats a number with a fixed number of decimal places.
- JOIN Concatenates the elements of one or more one-dimensional arrays using a specified delimiter.
- 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."
- LOWER Converts a specified string to lowercase.
- 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…
- PROPER Capitalizes each word in a specified string.
- 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.
- 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.
- SPLIT Divides text around a specified character or string, and puts each fragment into a separate cell in the…
- SUBSTITUTE Replaces existing text with new text in a string.
- T Returns string arguments as text.
- 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.
- TRIM Removes leading and trailing spaces in a specified string.
- UNICHAR Returns the Unicode character for a number.
- UNICODE Returns the decimal Unicode value of the first character of the text.
- 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…
Web · 8
- ENCODEURL Encodes a string of text for the purpose of using in a URL query.
- HYPERLINK Creates a hyperlink inside a cell.
- 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…
- ISURL Checks whether a value is a valid URL.