---
schema_version: "1"
id: cfd219b335e009724d31586167b85a5b5b3ebf21fe8c394409fa3b6161699bc6
title: Supported Formulas and Functions in Quip
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/quip_supported_formulas_and_functions.md
canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.quip_supported_formulas_and_functions.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 837ce0b6e10c97fedb0285bca33ef5cdd4cd40597d02214634dff293db65c176
description: Quip supports formulas and over 400 common functions.
products:
  - Quip
  - Cross Cloud
release: "264"
---
# Supported Formulas and Functions in Quip

Quip supports formulas and over 400 common functions.

 
| Formula | Description |
| --- | --- |
| ABS | Returns the absolute value of a number. |
| ACCRINT | Calculates the accrued interest of a security if there are periodic payments. |
| ACCRINTM | Calculates the accrued interest of a security if there’s a 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 | Returns the sum of two numbers. |
| AND | Returns TRUE if all arguments are TRUE. |
| ARABIC | Calculates the value of a Roman number. The value range must be from 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 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-squared 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-squared distribution. |
| CHISQ.DIST.RT | Returns the right-tail probability of the chi-squared 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-squared 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. |
| COL | Returns the column number of a specified cell. |
| 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 that is returned from a real coefficient and an imaginary coefficient. |
| CONCAT | Combines two strings into one string. |
| 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. |
| CONVERT | Converts a numeric value to a different unit of measure. |
| 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 | Counts the unique values in a list of specified values and ranges. |
| 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. Formats 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 before the settlement date. Formats 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. |
| DATEDIF | Calculates the number of days, months, or years between two dates. |
| DATEVALUE | Returns an internal number for a text having a possible date format. |
| DAY | Returns the sequential date of the month as an integer (from 1 through 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 from -512 through 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’s 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 | Returns the division of two numbers. |
| 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 | Returns TRUE if two values are equal and FALSE otherwise. |
| 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’re 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. |
| FILTER | Filters a range of data based on specified criteria. |
| 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. |
| FORMULATEXT | Returns the formula as a string. |
| 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. |
| 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 | Returns TRUE if the first value is strictly greater than the second value, and FALSE otherwise. |
| GTE | Returns TRUE if the first value is greater than or equal to the second value, and FALSE otherwise. |
| 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 (from 0 through 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 complex number 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 intersects the y-values by using known x-values and y-values. |
| IPMT | Calculates the periodic amortization 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 | Returns the ISO week number of the year for the date specified. |
| ISPMT | Calculates the level of interest for unchanged amortization installments. |
| JOIN | Combines values from one or more one-dimensional arrays using a specified separator. |
| KURT | Returns the kurtosis of a data set (at least 4 values required). |
| LARGE | Returns the Rank C, the 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 log-normal distribution. |
| LOGNORM.DIST | Values of the log normal distribution. |
| LOGNORM.INV | Values of the inverse of the log-normal distribution. |
| LOGNORMDIST | Returns the values of a log-normal 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 | Returns TRUE if the first value is strictly less than the second value, and FALSE otherwise. |
| LTE | Returns TRUE if the first value is less than or equal to the second value, and FALSE otherwise. |
| 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. Unlike the MAX function, you can enter text. The value of the text is 0. |
| MAXIFS | Returns the maximum value from a range of cells specified by a set of criteria. |
| 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 is the number in the middle of the set. In a set containing an even number of values, it’s 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. Unlike the MIN function, you can enter text. The value of the text is 0. |
| MINIFS | Returns the minimum value from a range of cells specified by a set of criteria. |
| MINUS | Returns the difference of two numbers. |
| MINUTE | Determines the sequential number for the minute of the hour (from 0 through 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 (from 1 through 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 | Returns the product of two numbers. |
| 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 | Returns TRUE if two values aren’t equal. Otherwise, returns FALSE. |
| 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 initial 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 | Returns a number raised to another number. |
| 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 from 0 through 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 or insert a specific cell or range of cells from a different spreadsheet. |
| REFERENCESHEET | Uses data referencing to reference or insert an entire spreadsheet. |
| REGEXEXTRACT | Extracts matching substrings according to a regular expression. |
| REGEXMATCH | Returns TRUE if specified text matches the regular expression and FALSE otherwise. |
| REGEXREPLACE | Replaces part of a text string with a different text string specified using a regular expression. |
| 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 from 0 through 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. |
| ROW | Returns the row number of a specified cell. |
| 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 (from 0 through 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. |
| SORT | Sorts data from a range or array. |
| 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 | To calculate the sum of the squares of numbers, totaling up of the squares of the arguments, enter SUMSQ 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 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 isn’t 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. |
| TEXT | Converts a number into text according to a specified format. |
| 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. |
| TRANSPOSE | Returns a horizontal range of cells as a vertical range, or vice versa. |
| 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 | Returns the specified number with its sign reversed. |
| UNARY\_PERCENT | Returns a number as a percentage. |
| 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. |
| UNIQUE | Returns unique values from a range of data. |
| UPLUS | Returns the specified number, unchanged. |
| 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 (from 1 through 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 that take place on different dates. |
| XNPV | Calculates the capital value (net present value) for a list of payments that 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. |

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-anywhere_app-264-0-0-production-enus/c0406050-7b26-469a-9dc5-10d6c0c9c576/images/icon_note.png)

Note The TEXT() formula only supports leading zeroes, comma separators, numbers, currency, dates, times, and percentages. The TEXT() formula doesn’t support fractions, custom formats, question marks (?), phone numbers, latitude, longitude, or accounting patterns.