Formulas and Functions in Quip

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")].

Here's a few things that are unique about our spreadsheet functionality:

Comment directly on a cell with an in-line comment.
Add a checkbox to a cell showing when things get done. When it's checked off, the whole row is checked off.
Bring any spreadsheet formula into the body of your document to bubble up the most important info. Simply type @forumula [=counta(parameters we want)].
Bring in Live Salesforce Reports to populate your spreadsheets (available for Quip Enterprise only after setup completion).
View Spreadsheet tabs in the context of a document canvas or just as a spreadsheet view by going to the top left Document or Spreadsheet button > Advanced > Layout.

For more information on Formula, refer to the Online Help:
Add Formulas and Functions to a Spreadsheet

Formula	Formula 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	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 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.
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 which 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. 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.
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 (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	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 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.
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 (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	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 (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	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-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	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. In opposite to MAX, here 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 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.
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 (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	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 are not equal and FALSE otherwise.
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	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 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	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 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.
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 (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.
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	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.
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 (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.

Considerations

TEXT() formula only supports leading 0’s, thousand separator, numbers, currency, dates, times, and percentages. The TEXT() formula does not support: fractions, custom formats, “?”, phone numbers, latitude and longitude and accounting patterns.

Questions/Feedback?
Reach out to our support team and log a case. Learn how to do that here.

Formulas and Functions in Quip

Considerations

General Information

Required Cookies

Functional Cookies

Advertising Cookies

General Information

Required Cookies

Functional Cookies

Advertising Cookies

Cookie List