Loading
Salesforce now sends email only from verified domains. Read More
Quip
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            . Supported Formulas and Functions in Quip

            You are here:

            1. Salesforce Help
            2. Docs
            3. Quip

            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
            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.
            .
             
            Loading
            Salesforce Help | Article