Yes! Quip supports formulas and over 400 common functions. Within a cell, start with an equals sign and functions will autocomplete as you type. [example: =COUNTIF(B2:B10,"64")].
Check below for a comprehensive overview of these 400+ functions!
| Function | Description |
|---|---|
| ABS | Returns the absolute value of a number. |
| ACCRINT | Calculates the accrued interest of a security in the case of periodic payments. |
| ACCRINTM | Calculates the accrued interest of a security in the case of one-off payment at the settlement date. |
| ACOS | Returns the inverse trigonometric cosine of a number. |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ACOT | Returns the inverse cotangent (the arccotangent) of the given number. |
| ACOTH | Returns the inverse hyperbolic cotangent of the given number. |
| ADD | |
| AND | Returns TRUE if all arguments are TRUE. |
| ARABIC | Calculates the value of a Roman number. The value range must be between 0 and 3999. |
| ASIN | Returns the inverse trigonometric sine of a number. |
| ASINH | Returns the inverse hyperbolic sine of a number. |
| ATAN | Returns the inverse trigonometric tangent of a number. |
| ATAN2 | Returns the inverse trigonometric tangent of the specified x and y coordinates. |
| ATANH | Returns the inverse hyperbolic tangent of a number. |
| AVEDEV | Returns the average of the absolute deviations of data points from their mean. |
| AVERAGE | Returns the average of the arguments. |
| AVERAGEA | Returns the average of the arguments. The value of a text is 0. |
| AVERAGEIF | Averages the arguments that meet the conditions. |
| AVERAGEIFS | Averages the value of the cells that meet multiple criteria in multiple ranges. |
| BASE | Converts a positive integer to a specified base into a text from the numbering system. |
| BESSELI | Returns the modified Bessel function In(x) |
| BESSELJ | Returns the Bessel function Jn(x) |
| BESSELK | Returns the Bessel function Kn(x) |
| BESSELY | Returns the Bessel function Yn(x) |
| BETA.DIST | Values of the beta distribution. |
| BETA.INV | Values of the inverse beta distribution. |
| BETADIST | Returns the beta function. |
| BETAINV | Returns the inverse of the cumulative beta probability density function. |
| BIN2DEC | The result is the decimal number for the binary number entered. |
| BIN2HEX | The result is the hexadecimal number for the binary number entered. |
| BIN2OCT | The result is the octal number for the binary number entered. |
| BINOM.DIST | Values of the binomial distribution. |
| BINOM.DIST.RANGE | Returns the probability of a trial result using binomial distribution. |
| BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| BINOMDIST | Returns the individual term binomial distribution probability. |
| BITAND | Returns a bitwise logical "and" of the parameters. |
| BITLSHIFT | Shifts a number left by n bits. |
| BITOR | Returns a bitwise logical "or" of the parameters. |
| BITRSHIFT | Shifts a number right by n bits. |
| BITXOR | Returns a bitwise logical "exclusive or" of the parameters. |
| CEILING | Rounds a number up to the nearest multiple of Significance. |
| CEILING.MATH | Rounds a number up to the nearest multiple of significance. |
| CEILING.PRECISE | Rounds a number up to the nearest multiple of significance, regardless of sign of significance. |
| CHAR | Converts a number into a character according to the current code table. |
| CHIDIST | Returns the probability value from the indicated Chi square that a hypothesis is confirmed. |
| CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution. |
| CHISQ.DIST | Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution. |
| CHISQ.DIST.RT | Returns the right-tail probability of the chi-square distribution. |
| CHISQ.INV | Values of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE()). |
| CHISQ.INV.RT | Values of the inverse of CHIDIST(x; DegreesOfFreedom). |
| CHISQ.TEST | Returns the chi square independence test. |
| CHITEST | Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence. |
| CHOOSE | Uses an index to return a value from a list of up to 30 values. |
| CLEAN | All non-printing characters are removed from the string. |
| CODE | Returns a numeric code for the first character in a text string. |
| COLUMNS | Returns the number of columns in the given reference. |
| COMBIN | Returns the number of combinations for elements without repetition. |
| COMBINA | Returns the number of combinations of a subset of items including repetitions. |
| COMPLEX | The result is a complex number which is returned from a real coefficient and an imaginary coefficient. |
| CONCAT | |
| CONCATENATE | Combines several text strings into one string. |
| CONFIDENCE | Returns the (1-alpha) confidence interval for a normal distribution. |
| CONFIDENCE.NORM | Returns a (1 alpha) confidence interval for a normal distribution. |
| CONFIDENCE.T | Returns a (1 alpha) confidence interval for a Student's t distribution. |
| CORREL | Returns the correlation coefficient between two data sets. |
| COS | Returns the cosine of the given angle (in radians). |
| COSH | Returns the hyperbolic cosine of a number. |
| COT | Returns the cotangent of the given angle (in radians). |
| COTH | Returns the hyperbolic cotangent of a given number (angle). |
| COUNT | Counts how many numbers are in the list of arguments. |
| COUNTA | Counts how many values are in the list of arguments. |
| COUNTBLANK | Returns the number of empty cells. |
| COUNTIF | Returns the number of cells that meet with certain criteria within a cell range. |
| COUNTIFS | Counts the cells that meet multiple criteria in multiple ranges. |
| COUNTUNIQUE | |
| COUPDAYBS | Returns the number of days from the first day of interest payment on a security until the settlement date. |
| COUPDAYS | Returns the number of days in the current interest period in which the settlement date falls. |
| COUPDAYSNC | Returns the number of days from the settlement date until the next interest date. |
| COUPNCD | Returns the date of the first interest date after the settlement date. Format the result as a date. |
| COUPNUM | Returns the number of coupons (interest payments) between the settlement date and the maturity date. |
| COUPPCD | Returns the date of the interest date prior to the settlement date. Format the result as a date. |
| COVAR | Returns the covariance of the product of paired deviations. |
| COVARIANCE.P | Calculates the population covariance. |
| COVARIANCE.S | Calculates the sample covariance. |
| CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |
| CSC | Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle |
| CSCH | Returns the hyperbolic cosecant of a number. |
| CUMIPMT | Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate. |
| CUMPRINC | Returns the cumulative interest paid for an investment period with a constant interest rate. |
| DATE | Provides an internal number for the date given. |
| DATEVALUE | Returns an internal number for a text having a possible date format. |
| DAY | Returns the sequential date of the month as an integer (1-31) in relation to the date value. |
| DAYS | Calculates the number of days between two dates. |
| DAYS360 | Calculates the number of days between two dates based on a 360-day year. |
| DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |
| DDB | Returns the depreciation of an asset for a specified period using the arithmetic-declining method. |
| DEC2BIN | The result is the binary number for the decimal number entered between -512 and 511. |
| DEC2HEX | The result is the hexadecimal number for the decimal number entered. |
| DEC2OCT | The result is the octal number for the decimal number entered. |
| DECIMAL | Converts text with characters from a number system to a positive integer in the base radix given. |
| DEGREES | Converts radians into degrees. |
| DELTA | The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0). |
| DEVSQ | Returns the sum of squares of deviations based on a sample mean. |
| DISC | Calculates the allowance (discount) of a security as a percentage. |
| DIVIDE | |
| DOLLAR | Converts a number to an amount in the currency format, rounded to a specified decimal place. |
| DOLLARDE | Converts a quotation that has been given as a decimal fraction into a decimal number. |
| DOLLARFR | Converts a quotation that has been given as a decimal number into a mixed decimal fraction. |
| DURATION | Calculates the number of periods required by an investment to attain the desired value. |
| EDATE | Returns the serial number of the date that is a specified number of months before or after the start date |
| EFFECT | Returns the effective annual interest rate |
| EOMONTH | Returns the serial number of the last day of the month that comes a certain number of months before or after the start date |
| EQ | |
| ERF | Returns values of the Gaussian error integral. |
| ERF.PRECISE | Returns the error function. |
| ERFC | Returns complementary values of the Gaussian error integral between x and infinity. |
| ERFC.PRECISE | Returns the complementary error function. |
| ERROR.TYPE | Returns a number corresponding to an error type |
| EVEN | Rounds a positive number up to the next even integer and a negative number down to the next even integer. |
| EXACT | Compares two text strings and returns TRUE if they are identical. |
| EXP | Returns e raised to the power of a number. |
| EXPON.DIST | Values of the exponential distribution. |
| EXPONDIST | Returns the exponential distribution. |
| F.DIST | Values of the left tail F probability distribution. |
| F.DIST.RT | Values of the right tail F probability distribution. |
| F.INV | Values of the inverse left tail F distribution. |
| F.INV.RT | Values of the inverse right tail F distribution. |
| F.TEST | Calculates the F test. |
| FACT | Returns the factorial of a number. |
| FACTDOUBLE | Returns the double factorial of a number. |
| FALSE | Returns the logical value FALSE. |
| FDIST | Calculates the values of an F distribution. |
| FIND | Looks for a string of text within another string. |
| FINV | Returns the inverse of the F probability distribution. |
| FISHER | Returns the Fisher transformation for x and creates a function close to a normal distribution. |
| FISHERINV | Returns the inverse of the Fisher transformation for x and creates a function close to a normal distribution. |
| FIXED | Returns a number as text with a specified number of decimal places and optional thousands separators. |
| FLOOR | Rounds a number down to the nearest multiple of Significance. |
| FLOOR.MATH | Rounds number down to the nearest multiple of significance. |
| FLOOR.PRECISE | Rounds number down to the nearest multiple of significance, regardless of sign of significance. |
| FORECAST | Extrapolates future values based on existing x and y values. |
| FTEST | Returns the result of an F test. |
| FV | Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value). |
| FVSCHEDULE | Calculates the accumulated value of the starting capital for a series of periodically varying interest rates. |
| GAMMA | Returns the Gamma function value. |
| GAMMA.DIST | Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution. |
| GAMMA.INV | Values of the inverse gamma distribution. |
| GAMMADIST | Returns the values of a Gamma distribution. |
| GAMMAINV | Returns the inverse of the Gamma cumulative distribution GAMMADIST. |
| GAMMALN | Returns the natural logarithm of the Gamma function: G(x). |
| GAMMALN.PRECISE | Returns the natural logarithm of the gamma function. |
| GAUSS | Returns the standard normal cumulative distribution. |
| GCD | Returns the greatest common divisor of two or more integers. |
| GEOMEAN | Returns the geometric mean of a sample. |
| GESTEP | The result is 1 if Number is greater than or equal to Step. |
| GT | |
| GTE | |
| HARMEAN | Returns the harmonic mean of a data set. |
| HEX2BIN | The result is the binary number for the hexadecimal number entered. |
| HEX2DEC | The result is the decimal number for the hexadecimal number entered. |
| HEX2OCT | The result is the octal number for the hexadecimal number entered. |
| HLOOKUP | Searches for a value and reference to the cells below the selected area. |
| HOUR | Determines the sequential number of the hour of the day (0-23) for the time value. |
| HYPGEOM.DIST | Values of the hypergeometric distribution. |
| HYPGEOMDIST | Returns the hypergeometric distribution. |
| IF | Specifies a logical test to be performed. |
| IFERROR | Returns value if not an error value, else alternative. |
| IFNA | Returns value if not a #N/A error, else alternative. |
| IMABS | The result is the absolute value of a complex number. |
| IMAGINARY | The result is the imaginary coefficient of a complex number. |
| IMARGUMENT | The result is the argument (the phi angle) of a complex number. |
| IMCONJUGATE | The result is the conjugated complex complement to a complex number. |
| IMCOS | The result is the cosine of a complex number. |
| IMCOSH | Returns the hyperbolic cosine of a complex number |
| IMCOT | Returns the cotangent of a complex number |
| IMCSC | Returns the cosecant of a complex number |
| IMCSCH | Returns the hyperbolic cosecant of a complex number |
| IMDIV | The result is the division of two complex numbers. |
| IMEXP | The result is the power of e and the complex number. |
| IMLN | The result is the natural logarithm (to the base e) of a complex number. |
| IMLOG10 | The result is the common logarithm (to the base 10) of a complex number. |
| IMLOG2 | The result is the binary logarithm of a complex number. |
| IMPOWER | The result is the ComplexNumber raised to the power of Number. |
| IMPRODUCT | The result is the product of up to 29 complex numbers. |
| IMREAL | The result is the real coefficient of a complex number. |
| IMSEC | Returns the secant of a complex number |
| IMSECH | Returns the hyperbolic secant of a complex number |
| IMSIN | The result is the sine of a complex number. |
| IMSINH | Returns the hyperbolic sine of a complex number |
| IMSQRT | The result is the square root of a complex number. |
| IMSUB | The result is the subtraction of two complex numbers. |
| IMSUM | The result is the sum of up to 29 complex numbers. |
| IMTAN | Returns the tangent of a complex number |
| INDEX | INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content. |
| INT | Rounds a number down to the nearest integer. |
| INTERCEPT | Calculates the point at which a line will intersect the y-values by using known x-values and y-values. |
| IPMT | Calculates the periodic amortizement for an investment with regular payments and a constant interest rate. |
| IRR | Calculates the internal rate of return for an investment. |
| ISBLANK | Returns TRUE if the reference to a cell is blank. |
| ISERROR | Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE. |
| ISEVEN | Returns TRUE if the value is an even integer, or FALSE if the value is odd. |
| ISNA | Returns TRUE if a cell contains the #N/A (value not available) error value. |
| ISNONTEXT | Tests if the cell contents are text or numbers, and returns FALSE if the contents are text. |
| ISNUMBER | Returns TRUE if the value refers to a number. |
| ISTEXT | Returns TRUE if the cell contents refer to text. |
| ISO.CEILING | Rounds a number up to the nearest multiple of significance, regardless of sign of significance. |
| ISODD | Returns TRUE if the value is odd, or FALSE if the number is even. |
| ISOWEEKNUM | |
| ISPMT | Calculates the level of interest for unchanged amortization installments. |
| JOIN | |
| KURT | Returns the kurtosis of a data set (at least 4 values required). |
| LARGE | Returns the Rank_c-th largest value in a data set. |
| LCM | Returns the least common multiple of one or more integers. |
| LEFT | Returns the first character or characters of a text. |
| LEN | Returns the length of a string including spaces. |
| LN | Returns the natural logarithm based on the constant e of a number. |
| LOG | Returns the logarithm of a number to the specified base. |
| LOG10 | Returns the base-10 logarithm of a number. |
| LOGINV | Returns the inverse of the lognormal distribution. |
| LOGNORM.DIST | Values of the log normal distribution. |
| LOGNORM.INV | Values of the inverse of the lognormal distribution. |
| LOGNORMDIST | Returns the values of a lognormal distribution. |
| LOOKUP | Returns the contents of a cell either from a one-row or one-column range. |
| LOWER | Converts all uppercase letters in a text string to lowercase. |
| LT | |
| LTE | |
| MATCH | Returns the relative position of an item in an array that matches a specified value. |
| MAX | Returns the maximum value in a list of arguments. |
| MAXA | Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0. |
| MDETERM | Returns the array determinant of an array. |
| MEDIAN | Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set. |
| MID | Returns a text string of a text. The parameters specify the starting position and the number of characters. |
| MIN | Returns the minimum value in a list of arguments. |
| MINA | Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0. |
| MINUS | |
| MINUTE | Determines the sequential number for the minute of the hour (0-59) for the time value. |
| MIRR | Calculates the modified internal rate of return of a series of investments. |
| MOD | Returns the remainder when one integer is divided by another. |
| MODE | Returns the most common value in a data set. |
| MODE.SNGL | Returns the most common value in a sample. |
| MONTH | Determines the sequential number of a month of the year (1-12) for the date value. |
| MROUND | Returns a number rounded to the nearest multiple of another number. |
| MULTINOMIAL | Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments. |
| MULTIPLY | |
| N | Returns the numeric value of the given parameter. Returns 0 if parameter is text or FALSE. |
| NA | Returns the error value #N/A. |
| NE | |
| NEGBINOM.DIST | Values of the negative binomial distribution. |
| NEGBINOMDIST | Returns the negative binomial distribution. |
| NETWORKDAYS | Returns the number of workdays between two dates |
| NETWORKDAYS.INTL | Returns the number of workdays between two dates using arguments to indicate weekend days and holidays. |
| NOMINAL | Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year. |
| NORM.DIST | Values of the normal distribution. |
| NORM.INV | Values of the inverse normal distribution. |
| NORM.S.DIST | The values of the standard normal distribution. |
| NORM.S.INV | Values of the inverse standard normal distribution. |
| NORMDIST | Returns the density function or the normal cumulative distribution. |
| NORMINV | Returns the inverse of the normal cumulative distribution. |
| NORMSDIST | Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one. |
| NORMSINV | Returns the inverse of the standard normal cumulative distribution. |
| NOT | Complements (inverts) a logical value. |
| NOW | Determines the current time of the computer. |
| NPER | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
| NPV | Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of itial cash flow at time zero) from the returned value. |
| NUMBERVALUE | Converts text to a number, in a locale-independent way. |
| OCT2BIN | The result is the binary number for the octal number entered. |
| OCT2DEC | The result is the decimal number for the octal number entered. |
| OCT2HEX | The result is the hexadecimal number for the octal number entered. |
| ODD | Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer. |
| OR | Returns TRUE if at least one argument is TRUE. |
| PDURATION | Duration. Calculates the number of periods required by an investment to attain the desired value. |
| PEARSON | Returns the Pearson product moment correlation coefficient r. |
| PERCENTILE | Returns the alpha-percentile of data values in an array. |
| PERCENTILE.EXC | Returns the alpha percentile of a sample. |
| PERCENTILE.INC | Returns the alpha percentile of a sample. |
| PERCENTRANK | Returns the percentage rank of a value in a sample. |
| PERCENTRANK.EXC | Returns the percentage rank (0..1, exclusive) of a value in a sample. |
| PERCENTRANK.INC | Returns the percentage rank (0..1, inclusive) of a value in a sample. |
| PERMUT | Returns the number of permutations for a given number of objects. |
| PERMUTATIONA | Returns the number of permutations for a given number of objects (repetition allowed). |
| PHI | Returns the values of the distribution function for a standard normal distribution. |
| PI | Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places. |
| PMT | Returns the periodic payment for an annuity with constant interest rates. |
| POISSON | Returns the Poisson distribution. |
| POISSON.DIST | Returns the Poisson distribution. |
| POW | |
| POWER | Returns a number raised to another number. |
| PPMT | Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate. |
| PRICE | Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield. |
| PRICEDISC | Calculates the price per 100 currency units of par value of a non-interest- bearing security. |
| PRICEMAT | Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date. |
| PROB | Returns the probability that values in a range are between two limits. |
| PRODUCT | Multiplies all the numbers given as arguments and returns the product. |
| PROPER | Capitalizes the first letter in all words of a text string. |
| PV | Returns the present value of an investment resulting from a series of regular payments. |
| QUARTILE | Returns the quartile of a data set. |
| QUARTILE.EXC | Returns the quartile of a sample. |
| QUARTILE.INC | Returns the quartile of a sample. |
| QUOTIENT | Returns the integer part of a division operation. |
| RADIANS | Converts degrees to radians. |
| RAND | Returns a random number between 0 and 1. |
| RANDBETWEEN | Returns an integer random number in a specified range. |
| RANK | Returns the rank of a number in a sample. |
| RANK.AVG | Returns the ranking of a value in a sample; if more than one value has the same rank, the average rank is returned. |
| RANK.EQ | Returns the ranking of a value in a sample; if more than one value has the same rank, the top rank of that set of values is returned. |
| RATE | Returns the constant interest rate per period of an annuity. |
| RECEIVED | Calculates the amount received that is paid for a fixed-interest security at a given point in time. |
| REFERENCERANGE | Uses data referencing to reference/insert a specific cell or range of cells from a different spreadsheet |
| REFERENCESHEET | Uses data referencing to reference/insert an entire spreadsheet |
| REGEXEXTRACT | |
| REGEXMATCH | |
| REGEXREPLACE | |
| REPLACE | Replaces part of a text string with a different text string. |
| REPT | Repeats a character string by the given number of copies. |
| RIGHT | Returns the last character or characters of a text. |
| ROMAN | Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4. |
| ROUND | Rounds a number to a certain number of decimal places. |
| ROUNDDOWN | Rounds a number down, toward zero, to a certain precision. |
| ROUNDUP | Rounds a number up, away from zero, to a certain precision. |
| ROWS | Returns the number of rows in a reference or array. |
| RRI | Calculates the interest rate resulting from the profit (return) of an investment. |
| RSQ | Returns the square of the Pearson correlation coefficient based on the given values. |
| SEARCH | Returns the position of a text segment within a character string. |
| SEC | Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle |
| SECH | Returns the hyperbolic secant of a number. |
| SECOND | Determines the sequential number of the second of a minute (0-59) for the time value. |
| SERIESSUM | Sums the first terms of a power series. |
| SIGN | Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero. |
| SIN | Returns the sine of the given angle (in radians). |
| SINH | Returns the hyperbolic sine of a number. |
| SKEW | Returns the skewness of a distribution. |
| SKEW.P | Returns the skewness of a distribution using the population of a random variable. |
| SLN | Returns the straight-line depreciation of an asset for one period. |
| SLOPE | Returns the slope of the linear regression line. |
| SMALL | Returns the Rank_c-th smallest value in a data set. |
| SQRT | Returns the positive square root of a number. |
| SQRTPI | Returns the square root of (PI times a number). |
| STANDARDIZE | Converts a random variable to a normalized value. |
| STDEV | Estimates the standard deviation based on a sample. |
| STDEV.P | Calculates the standard deviation based on the entire population. |
| STDEV.S | Calculates the standard deviation based on a sample. |
| STDEVA | Calculates the standard deviation of an estimation based on a sample. |
| STDEVP | Calculates the standard deviation based on the entire population. |
| STDEVPA | Calculates the standard deviation based on the entire population. |
| STEYX | Returns the standard error of the predicted y value for each x in the regression. |
| SUBSTITUTE | Substitutes new text for old text in a string. |
| SUM | Adds all the numbers in a range of cells. |
| SUMIF | Adds the cells specified by a given criteria. |
| SUMIFS | Totals the values of cells in a range that meet multiple criteria in multiple ranges. |
| SUMPRODUCT | Multiplies corresponding elements in the given arrays, and returns the sum of those products. |
| SUMSQ | If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields. |
| SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays. |
| SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays. |
| SUMXMY2 | Adds the squares of the variance between corresponding values in two arrays. |
| SYD | Returns the arithmetic-declining depreciation rate. |
| T | This function returns the target text, or a blank text string if the target is not text. |
| T.DIST | Returns the t-distribution. |
| T.DIST.2T | Returns the two-tailed t-distribution. |
| T.DIST.RT | Returns the right-tailed t-distribution. |
| T.INV | Values of the left-tailed inverse t-distribution. |
| T.INV.2T | Values of the two-tailed inverse t-distribution. |
| T.TEST | Calculates the T test. |
| TAN | Returns the tangent of the given angle (in radians). |
| TANH | Returns the hyperbolic tangent of a number. |
| TBILLEQ | Calculates the annual return on a treasury bill. |
| TBILLPRICE | Calculates the price of a treasury bill per 100 currency units. |
| TBILLYIELD | Calculates the yield of a treasury bill. |
| TDIST | Returns the t-distribution. |
| TIME | Determines a time value from the details for hour, minute and second. |
| TIMEVALUE | Returns a sequential number for a text shown in a possible time entry format. |
| TINV | Returns the inverse of the t-distribution. |
| TODAY | Determines the current date of the computer. |
| TRIM | Removes spaces from a string, leaving only a single space character between words. |
| TRIMMEAN | Returns the mean of a data set without the Alpha percent of data at the margins. |
| TRUE | The logical value is set to TRUE. |
| TRUNC | Truncates a number by removing decimal places. |
| TTEST | Returns the probability associated with a Student's t-Test. |
| TYPE | Returns the type of value. |
| UMINUS | |
| UNARY_PERCENT | |
| UNICHAR | Converts a code number into a Unicode character or letter. |
| UNICODE | Returns the numeric code for the first Unicode character in a text string. |
| UPLUS | |
| UPPER | Converts the string specified in the text field to uppercase. |
| VALUE | Converts a text string into a number. |
| VAR | Estimates the variance based on a sample. |
| VAR.P | Calculates variance based on the entire population. |
| VAR.S | Calculates the variance based on a sample. |
| VARA | Estimates a variance based on a sample. The value of text is 0. |
| VARP | Calculates a variance based on the entire population. |
| VARPA | Calculates the variance based on the entire population. The value of text is 0. |
| VLOOKUP | Vertical search with reference to adjacent cells to the right. |
| WEEKDAY | Returns the day of the week for the date value as an integer (1-7). |
| WEEKNUM | Returns the number of the calendar week in which the specified date occurs. |
| WEIBULL | Returns the values of the Weibull distribution. |
| WEIBULL.DIST | Returns the values of the Weibull distribution. |
| WORKDAY | Returns the serial number of the date before or after a specified number of workdays |
| WORKDAY.INTL | Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays. |
| XIRR | Calculates the internal rate of return for a list of payments which take place on different dates. |
| XNPV | Calculates the capital value (net present value)for a list of payments which take place on different dates. |
| XOR | Returns true if an odd number of arguments evaluates to TRUE. |
| YEAR | Returns the year of a date value as an integer. |
| YEARFRAC | Returns the number of years (including fractional part) between two dates |
| YIELD | Calculates the yield of a security. |
| ZOIDBERG | Why not Zoidberg? |
| Z.TEST | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. |
| ZTEST | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. |