## Are there formulas and functions?

Yes! Quip supports formulas and over 400 common functions. Within a cell, start with an equals sign and functions will autocomplete as you type. [example: =COUNTIF(B2:B10,"64")].

**Check below for a comprehensive overview of these 400+ functions!**

Function | Description |
---|---|

ABS | Returns the absolute value of a number. |

ACCRINT | Calculates the accrued interest of a security in the case of periodic payments. |

ACCRINTM | Calculates the accrued interest of a security in the case of one-off payment at the settlement date. |

ACOS | Returns the inverse trigonometric cosine of a number. |

ACOSH | Returns the inverse hyperbolic cosine of a number. |

ACOT | Returns the inverse cotangent (the arccotangent) of the given number. |

ACOTH | Returns the inverse hyperbolic cotangent of the given number. |

ADD | |

AND | Returns TRUE if all arguments are TRUE. |

ARABIC | Calculates the value of a Roman number. The value range must be between 0 and 3999. |

ASIN | Returns the inverse trigonometric sine of a number. |

ASINH | Returns the inverse hyperbolic sine of a number. |

ATAN | Returns the inverse trigonometric tangent of a number. |

ATAN2 | Returns the inverse trigonometric tangent of the specified x and y coordinates. |

ATANH | Returns the inverse hyperbolic tangent of a number. |

AVEDEV | Returns the average of the absolute deviations of data points from their mean. |

AVERAGE | Returns the average of the arguments. |

AVERAGEA | Returns the average of the arguments. The value of a text is 0. |

AVERAGEIF | Averages the arguments that meet the conditions. |

AVERAGEIFS | Averages the value of the cells that meet multiple criteria in multiple ranges. |

BASE | Converts a positive integer to a specified base into a text from the numbering system. |

BESSELI | Returns the modified Bessel function In(x) |

BESSELJ | Returns the Bessel function Jn(x) |

BESSELK | Returns the Bessel function Kn(x) |

BESSELY | Returns the Bessel function Yn(x) |

BETA.DIST | Values of the beta distribution. |

BETA.INV | Values of the inverse beta distribution. |

BETADIST | Returns the beta function. |

BETAINV | Returns the inverse of the cumulative beta probability density function. |

BIN2DEC | The result is the decimal number for the binary number entered. |

BIN2HEX | The result is the hexadecimal number for the binary number entered. |

BIN2OCT | The result is the octal number for the binary number entered. |

BINOM.DIST | Values of the binomial distribution. |

BINOM.DIST.RANGE | Returns the probability of a trial result using binomial distribution. |

BINOM.INV | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |

BINOMDIST | Returns the individual term binomial distribution probability. |

BITAND | Returns a bitwise logical "and" of the parameters. |

BITLSHIFT | Shifts a number left by n bits. |

BITOR | Returns a bitwise logical "or" of the parameters. |

BITRSHIFT | Shifts a number right by n bits. |

BITXOR | Returns a bitwise logical "exclusive or" of the parameters. |

CEILING | Rounds a number up to the nearest multiple of Significance. |

CEILING.MATH | Rounds a number up to the nearest multiple of significance. |

CEILING.PRECISE | Rounds a number up to the nearest multiple of significance, regardless of sign of significance. |

CHAR | Converts a number into a character according to the current code table. |

CHIDIST | Returns the probability value from the indicated Chi square that a hypothesis is confirmed. |

CHIINV | Returns the inverse of the one-tailed probability of the chi-squared distribution. |

CHISQ.DIST | Returns left-tail probability of the cumulative distribution function or values of the probability density function of the chi-square distribution. |

CHISQ.DIST.RT | Returns the right-tail probability of the chi-square distribution. |

CHISQ.INV | Values of the inverse of CHISQ.DIST(x;DegreesOfFreedom;TRUE()). |

CHISQ.INV.RT | Values of the inverse of CHIDIST(x; DegreesOfFreedom). |

CHISQ.TEST | Returns the chi square independence test. |

CHITEST | Returns the probability of a deviance from a random distribution of two test series based on the chi-squared test for independence. |

CHOOSE | Uses an index to return a value from a list of up to 30 values. |

CLEAN | All non-printing characters are removed from the string. |

CODE | Returns a numeric code for the first character in a text string. |

COLUMNS | Returns the number of columns in the given reference. |

COMBIN | Returns the number of combinations for elements without repetition. |

COMBINA | Returns the number of combinations of a subset of items including repetitions. |

COMPLEX | The result is a complex number which is returned from a real coefficient and an imaginary coefficient. |

CONCAT | |

CONCATENATE | Combines several text strings into one string. |

CONFIDENCE | Returns the (1-alpha) confidence interval for a normal distribution. |

CONFIDENCE.NORM | Returns a (1 alpha) confidence interval for a normal distribution. |

CONFIDENCE.T | Returns a (1 alpha) confidence interval for a Student's t distribution. |

CORREL | Returns the correlation coefficient between two data sets. |

COS | Returns the cosine of the given angle (in radians). |

COSH | Returns the hyperbolic cosine of a number. |

COT | Returns the cotangent of the given angle (in radians). |

COTH | Returns the hyperbolic cotangent of a given number (angle). |

COUNT | Counts how many numbers are in the list of arguments. |

COUNTA | Counts how many values are in the list of arguments. |

COUNTBLANK | Returns the number of empty cells. |

COUNTIF | Returns the number of cells that meet with certain criteria within a cell range. |

COUNTIFS | Counts the cells that meet multiple criteria in multiple ranges. |

COUNTUNIQUE | |

COUPDAYBS | Returns the number of days from the first day of interest payment on a security until the settlement date. |

COUPDAYS | Returns the number of days in the current interest period in which the settlement date falls. |

COUPDAYSNC | Returns the number of days from the settlement date until the next interest date. |

COUPNCD | Returns the date of the first interest date after the settlement date. Format the result as a date. |

COUPNUM | Returns the number of coupons (interest payments) between the settlement date and the maturity date. |

COUPPCD | Returns the date of the interest date prior to the settlement date. Format the result as a date. |

COVAR | Returns the covariance of the product of paired deviations. |

COVARIANCE.P | Calculates the population covariance. |

COVARIANCE.S | Calculates the sample covariance. |

CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. |

CSC | Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle |

CSCH | Returns the hyperbolic cosecant of a number. |

CUMIPMT | Calculates the cumulative interest payments, that is, the total interest, for an investment based on a constant interest rate. |

CUMPRINC | Returns the cumulative interest paid for an investment period with a constant interest rate. |

DATE | Provides an internal number for the date given. |

DATEVALUE | Returns an internal number for a text having a possible date format. |

DAY | Returns the sequential date of the month as an integer (1-31) in relation to the date value. |

DAYS | Calculates the number of days between two dates. |

DAYS360 | Calculates the number of days between two dates based on a 360-day year. |

DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |

DDB | Returns the depreciation of an asset for a specified period using the arithmetic-declining method. |

DEC2BIN | The result is the binary number for the decimal number entered between -512 and 511. |

DEC2HEX | The result is the hexadecimal number for the decimal number entered. |

DEC2OCT | The result is the octal number for the decimal number entered. |

DECIMAL | Converts text with characters from a number system to a positive integer in the base radix given. |

DEGREES | Converts radians into degrees. |

DELTA | The result is TRUE (1) if both numbers, which are delivered as an argument, are equal, otherwise it is FALSE (0). |

DEVSQ | Returns the sum of squares of deviations based on a sample mean. |

DISC | Calculates the allowance (discount) of a security as a percentage. |

DIVIDE | |

DOLLAR | Converts a number to an amount in the currency format, rounded to a specified decimal place. |

DOLLARDE | Converts a quotation that has been given as a decimal fraction into a decimal number. |

DOLLARFR | Converts a quotation that has been given as a decimal number into a mixed decimal fraction. |

DURATION | Calculates the number of periods required by an investment to attain the desired value. |

EDATE | Returns the serial number of the date that is a specified number of months before or after the start date |

EFFECT | Returns the effective annual interest rate |

EOMONTH | Returns the serial number of the last day of the month that comes a certain number of months before or after the start date |

EQ | |

ERF | Returns values of the Gaussian error integral. |

ERF.PRECISE | Returns the error function. |

ERFC | Returns complementary values of the Gaussian error integral between x and infinity. |

ERFC.PRECISE | Returns the complementary error function. |

ERROR.TYPE | Returns a number corresponding to an error type |

EVEN | Rounds a positive number up to the next even integer and a negative number down to the next even integer. |

EXACT | Compares two text strings and returns TRUE if they are identical. |

EXP | Returns e raised to the power of a number. |

EXPON.DIST | Values of the exponential distribution. |

EXPONDIST | Returns the exponential distribution. |

F.DIST | Values of the left tail F probability distribution. |

F.DIST.RT | Values of the right tail F probability distribution. |

F.INV | Values of the inverse left tail F distribution. |

F.INV.RT | Values of the inverse right tail F distribution. |

F.TEST | Calculates the F test. |

FACT | Returns the factorial of a number. |

FACTDOUBLE | Returns the double factorial of a number. |

FALSE | Returns the logical value FALSE. |

FDIST | Calculates the values of an F distribution. |

FIND | Looks for a string of text within another string. |

FINV | Returns the inverse of the F probability distribution. |

FISHER | Returns the Fisher transformation for x and creates a function close to a normal distribution. |

FISHERINV | Returns the inverse of the Fisher transformation for x and creates a function close to a normal distribution. |

FIXED | Returns a number as text with a specified number of decimal places and optional thousands separators. |

FLOOR | Rounds a number down to the nearest multiple of Significance. |

FLOOR.MATH | Rounds number down to the nearest multiple of significance. |

FLOOR.PRECISE | Rounds number down to the nearest multiple of significance, regardless of sign of significance. |

FORECAST | Extrapolates future values based on existing x and y values. |

FTEST | Returns the result of an F test. |

FV | Returns the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value). |

FVSCHEDULE | Calculates the accumulated value of the starting capital for a series of periodically varying interest rates. |

GAMMA | Returns the Gamma function value. |

GAMMA.DIST | Returns the value of the probability density function or the cumulative distribution function for the Gamma distribution. |

GAMMA.INV | Values of the inverse gamma distribution. |

GAMMADIST | Returns the values of a Gamma distribution. |

GAMMAINV | Returns the inverse of the Gamma cumulative distribution GAMMADIST. |

GAMMALN | Returns the natural logarithm of the Gamma function: G(x). |

GAMMALN.PRECISE | Returns the natural logarithm of the gamma function. |

GAUSS | Returns the standard normal cumulative distribution. |

GCD | Returns the greatest common divisor of two or more integers. |

GEOMEAN | Returns the geometric mean of a sample. |

GESTEP | The result is 1 if Number is greater than or equal to Step. |

GT | |

GTE | |

HARMEAN | Returns the harmonic mean of a data set. |

HEX2BIN | The result is the binary number for the hexadecimal number entered. |

HEX2DEC | The result is the decimal number for the hexadecimal number entered. |

HEX2OCT | The result is the octal number for the hexadecimal number entered. |

HLOOKUP | Searches for a value and reference to the cells below the selected area. |

HOUR | Determines the sequential number of the hour of the day (0-23) for the time value. |

HYPGEOM.DIST | Values of the hypergeometric distribution. |

HYPGEOMDIST | Returns the hypergeometric distribution. |

IF | Specifies a logical test to be performed. |

IFERROR | Returns value if not an error value, else alternative. |

IFNA | Returns value if not a #N/A error, else alternative. |

IMABS | The result is the absolute value of a complex number. |

IMAGINARY | The result is the imaginary coefficient of a complex number. |

IMARGUMENT | The result is the argument (the phi angle) of a complex number. |

IMCONJUGATE | The result is the conjugated complex complement to a complex number. |

IMCOS | The result is the cosine of a complex number. |

IMCOSH | Returns the hyperbolic cosine of a complex number |

IMCOT | Returns the cotangent of a complex number |

IMCSC | Returns the cosecant of a complex number |

IMCSCH | Returns the hyperbolic cosecant of a complex number |

IMDIV | The result is the division of two complex numbers. |

IMEXP | The result is the power of e and the complex number. |

IMLN | The result is the natural logarithm (to the base e) of a complex number. |

IMLOG10 | The result is the common logarithm (to the base 10) of a complex number. |

IMLOG2 | The result is the binary logarithm of a complex number. |

IMPOWER | The result is the ComplexNumber raised to the power of Number. |

IMPRODUCT | The result is the product of up to 29 complex numbers. |

IMREAL | The result is the real coefficient of a complex number. |

IMSEC | Returns the secant of a complex number |

IMSECH | Returns the hyperbolic secant of a complex number |

IMSIN | The result is the sine of a complex number. |

IMSINH | Returns the hyperbolic sine of a complex number |

IMSQRT | The result is the square root of a complex number. |

IMSUB | The result is the subtraction of two complex numbers. |

IMSUM | The result is the sum of up to 29 complex numbers. |

IMTAN | Returns the tangent of a complex number |

INDEX | INDEX returns a sub range, specified by row and column number, or an optional range index. Depending on context, INDEX returns a reference or content. |

INT | Rounds a number down to the nearest integer. |

INTERCEPT | Calculates the point at which a line will intersect the y-values by using known x-values and y-values. |

IPMT | Calculates the periodic amortizement for an investment with regular payments and a constant interest rate. |

IRR | Calculates the internal rate of return for an investment. |

ISBLANK | Returns TRUE if the reference to a cell is blank. |

ISERROR | Tests for error conditions, including the #N/A error value, and returns TRUE or FALSE. |

ISEVEN | Returns TRUE if the value is an even integer, or FALSE if the value is odd. |

ISNA | Returns TRUE if a cell contains the #N/A (value not available) error value. |

ISNONTEXT | Tests if the cell contents are text or numbers, and returns FALSE if the contents are text. |

ISNUMBER | Returns TRUE if the value refers to a number. |

ISTEXT | Returns TRUE if the cell contents refer to text. |

ISO.CEILING | Rounds a number up to the nearest multiple of significance, regardless of sign of significance. |

ISODD | Returns TRUE if the value is odd, or FALSE if the number is even. |

ISOWEEKNUM | |

ISPMT | Calculates the level of interest for unchanged amortization installments. |

JOIN | |

KURT | Returns the kurtosis of a data set (at least 4 values required). |

LARGE | Returns the Rank_c-th largest value in a data set. |

LCM | Returns the least common multiple of one or more integers. |

LEFT | Returns the first character or characters of a text. |

LEN | Returns the length of a string including spaces. |

LN | Returns the natural logarithm based on the constant e of a number. |

LOG | Returns the logarithm of a number to the specified base. |

LOG10 | Returns the base-10 logarithm of a number. |

LOGINV | Returns the inverse of the lognormal distribution. |

LOGNORM.DIST | Values of the log normal distribution. |

LOGNORM.INV | Values of the inverse of the lognormal distribution. |

LOGNORMDIST | Returns the values of a lognormal distribution. |

LOOKUP | Returns the contents of a cell either from a one-row or one-column range. |

LOWER | Converts all uppercase letters in a text string to lowercase. |

LT | |

LTE | |

MATCH | Returns the relative position of an item in an array that matches a specified value. |

MAX | Returns the maximum value in a list of arguments. |

MAXA | Returns the maximum value in a list of arguments. In opposite to MAX, here you can enter text. The value of the text is 0. |

MDETERM | Returns the array determinant of an array. |

MEDIAN | Returns the median of a set of numbers. In a set containing an uneven number of values, the median will be the number in the middle of the set and in a set containing an even number of values, it will be the mean of the two values in the middle of the set. |

MID | Returns a text string of a text. The parameters specify the starting position and the number of characters. |

MIN | Returns the minimum value in a list of arguments. |

MINA | Returns the minimum value in a list of arguments. Here you can also enter text. The value of the text is 0. |

MINUS | |

MINUTE | Determines the sequential number for the minute of the hour (0-59) for the time value. |

MIRR | Calculates the modified internal rate of return of a series of investments. |

MOD | Returns the remainder when one integer is divided by another. |

MODE | Returns the most common value in a data set. |

MODE.SNGL | Returns the most common value in a sample. |

MONTH | Determines the sequential number of a month of the year (1-12) for the date value. |

MROUND | Returns a number rounded to the nearest multiple of another number. |

MULTINOMIAL | Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments. |

MULTIPLY | |

N | Returns the numeric value of the given parameter. Returns 0 if parameter is text or FALSE. |

NA | Returns the error value #N/A. |

NE | |

NEGBINOM.DIST | Values of the negative binomial distribution. |

NEGBINOMDIST | Returns the negative binomial distribution. |

NETWORKDAYS | Returns the number of workdays between two dates |

NETWORKDAYS.INTL | Returns the number of workdays between two dates using arguments to indicate weekend days and holidays. |

NOMINAL | Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year. |

NORM.DIST | Values of the normal distribution. |

NORM.INV | Values of the inverse normal distribution. |

NORM.S.DIST | The values of the standard normal distribution. |

NORM.S.INV | Values of the inverse standard normal distribution. |

NORMDIST | Returns the density function or the normal cumulative distribution. |

NORMINV | Returns the inverse of the normal cumulative distribution. |

NORMSDIST | Returns the standard normal cumulative distribution function. The distribution has a mean of zero and a standard deviation of one. |

NORMSINV | Returns the inverse of the standard normal cumulative distribution. |

NOT | Complements (inverts) a logical value. |

NOW | Determines the current time of the computer. |

NPER | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |

NPV | Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of itial cash flow at time zero) from the returned value. |

NUMBERVALUE | Converts text to a number, in a locale-independent way. |

OCT2BIN | The result is the binary number for the octal number entered. |

OCT2DEC | The result is the decimal number for the octal number entered. |

OCT2HEX | The result is the hexadecimal number for the octal number entered. |

ODD | Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer. |

OR | Returns TRUE if at least one argument is TRUE. |

PDURATION | Duration. Calculates the number of periods required by an investment to attain the desired value. |

PEARSON | Returns the Pearson product moment correlation coefficient r. |

PERCENTILE | Returns the alpha-percentile of data values in an array. |

PERCENTILE.EXC | Returns the alpha percentile of a sample. |

PERCENTILE.INC | Returns the alpha percentile of a sample. |

PERCENTRANK | Returns the percentage rank of a value in a sample. |

PERCENTRANK.EXC | Returns the percentage rank (0..1, exclusive) of a value in a sample. |

PERCENTRANK.INC | Returns the percentage rank (0..1, inclusive) of a value in a sample. |

PERMUT | Returns the number of permutations for a given number of objects. |

PERMUTATIONA | Returns the number of permutations for a given number of objects (repetition allowed). |

PHI | Returns the values of the distribution function for a standard normal distribution. |

PI | Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places. |

PMT | Returns the periodic payment for an annuity with constant interest rates. |

POISSON | Returns the Poisson distribution. |

POISSON.DIST | Returns the Poisson distribution. |

POW | |

POWER | Returns a number raised to another number. |

PPMT | Returns for a given period the payment on the principal for an investment that is based on periodic and constant payments and a constant interest rate. |

PRICE | Calculates the market value of a fixed interest security with a par value of 100 currency units as a function of the forecast yield. |

PRICEDISC | Calculates the price per 100 currency units of par value of a non-interest- bearing security. |

PRICEMAT | Calculates the price per 100 currency units of par value of a security, that pays interest on the maturity date. |

PROB | Returns the probability that values in a range are between two limits. |

PRODUCT | Multiplies all the numbers given as arguments and returns the product. |

PROPER | Capitalizes the first letter in all words of a text string. |

PV | Returns the present value of an investment resulting from a series of regular payments. |

QUARTILE | Returns the quartile of a data set. |

QUARTILE.EXC | Returns the quartile of a sample. |

QUARTILE.INC | Returns the quartile of a sample. |

QUOTIENT | Returns the integer part of a division operation. |

RADIANS | Converts degrees to radians. |

RAND | Returns a random number between 0 and 1. |

RANDBETWEEN | Returns an integer random number in a specified range. |

RANK | Returns the rank of a number in a sample. |

RANK.AVG | Returns the ranking of a value in a sample; if more than one value has the same rank, the average rank is returned. |

RANK.EQ | Returns the ranking of a value in a sample; if more than one value has the same rank, the top rank of that set of values is returned. |

RATE | Returns the constant interest rate per period of an annuity. |

RECEIVED | Calculates the amount received that is paid for a fixed-interest security at a given point in time. |

REGEXEXTRACT | |

REGEXMATCH | |

REGEXREPLACE | |

REPLACE | Replaces part of a text string with a different text string. |

REPT | Repeats a character string by the given number of copies. |

RIGHT | Returns the last character or characters of a text. |

ROMAN | Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4. |

ROUND | Rounds a number to a certain number of decimal places. |

ROUNDDOWN | Rounds a number down, toward zero, to a certain precision. |

ROUNDUP | Rounds a number up, away from zero, to a certain precision. |

ROWS | Returns the number of rows in a reference or array. |

RRI | Calculates the interest rate resulting from the profit (return) of an investment. |

RSQ | Returns the square of the Pearson correlation coefficient based on the given values. |

SEARCH | Returns the position of a text segment within a character string. |

SEC | Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle |

SECH | Returns the hyperbolic secant of a number. |

SECOND | Determines the sequential number of the second of a minute (0-59) for the time value. |

SERIESSUM | Sums the first terms of a power series. |

SIGN | Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero. |

SIN | Returns the sine of the given angle (in radians). |

SINH | Returns the hyperbolic sine of a number. |

SKEW | Returns the skewness of a distribution. |

SKEW.P | Returns the skewness of a distribution using the population of a random variable. |

SLN | Returns the straight-line depreciation of an asset for one period. |

SLOPE | Returns the slope of the linear regression line. |

SMALL | Returns the Rank_c-th smallest value in a data set. |

SQRT | Returns the positive square root of a number. |

SQRTPI | Returns the square root of (PI times a number). |

STANDARDIZE | Converts a random variable to a normalized value. |

STDEV | Estimates the standard deviation based on a sample. |

STDEV.P | Calculates the standard deviation based on the entire population. |

STDEV.S | Calculates the standard deviation based on a sample. |

STDEVA | Calculates the standard deviation of an estimation based on a sample. |

STDEVP | Calculates the standard deviation based on the entire population. |

STDEVPA | Calculates the standard deviation based on the entire population. |

STEYX | Returns the standard error of the predicted y value for each x in the regression. |

SUBSTITUTE | Substitutes new text for old text in a string. |

SUM | Adds all the numbers in a range of cells. |

SUMIF | Adds the cells specified by a given criteria. |

SUMIFS | Totals the values of cells in a range that meet multiple criteria in multiple ranges. |

SUMPRODUCT | Multiplies corresponding elements in the given arrays, and returns the sum of those products. |

SUMSQ | If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields. |

SUMX2MY2 | Returns the sum of the difference of squares of corresponding values in two arrays. |

SUMX2PY2 | Returns the sum of the sum of squares of corresponding values in two arrays. |

SUMXMY2 | Adds the squares of the variance between corresponding values in two arrays. |

SYD | Returns the arithmetic-declining depreciation rate. |

T | This function returns the target text, or a blank text string if the target is not text. |

T.DIST | Returns the t-distribution. |

T.DIST.2T | Returns the two-tailed t-distribution. |

T.DIST.RT | Returns the right-tailed t-distribution. |

T.INV | Values of the left-tailed inverse t-distribution. |

T.INV.2T | Values of the two-tailed inverse t-distribution. |

T.TEST | Calculates the T test. |

TAN | Returns the tangent of the given angle (in radians). |

TANH | Returns the hyperbolic tangent of a number. |

TBILLEQ | Calculates the annual return on a treasury bill. |

TBILLPRICE | Calculates the price of a treasury bill per 100 currency units. |

TBILLYIELD | Calculates the yield of a treasury bill. |

TDIST | Returns the t-distribution. |

TIME | Determines a time value from the details for hour, minute and second. |

TIMEVALUE | Returns a sequential number for a text shown in a possible time entry format. |

TINV | Returns the inverse of the t-distribution. |

TODAY | Determines the current date of the computer. |

TRIM | Removes spaces from a string, leaving only a single space character between words. |

TRIMMEAN | Returns the mean of a data set without the Alpha percent of data at the margins. |

TRUE | The logical value is set to TRUE. |

TRUNC | Truncates a number by removing decimal places. |

TTEST | Returns the probability associated with a Student's t-Test. |

TYPE | Returns the type of value. |

UMINUS | |

UNARY_PERCENT | |

UNICHAR | Converts a code number into a Unicode character or letter. |

UNICODE | Returns the numeric code for the first Unicode character in a text string. |

UPLUS | |

UPPER | Converts the string specified in the text field to uppercase. |

VALUE | Converts a text string into a number. |

VAR | Estimates the variance based on a sample. |

VAR.P | Calculates variance based on the entire population. |

VAR.S | Calculates the variance based on a sample. |

VARA | Estimates a variance based on a sample. The value of text is 0. |

VARP | Calculates a variance based on the entire population. |

VARPA | Calculates the variance based on the entire population. The value of text is 0. |

VLOOKUP | Vertical search with reference to adjacent cells to the right. |

WEEKDAY | Returns the day of the week for the date value as an integer (1-7). |

WEEKNUM | Returns the number of the calendar week in which the specified date occurs. |

WEIBULL | Returns the values of the Weibull distribution. |

WEIBULL.DIST | Returns the values of the Weibull distribution. |

WORKDAY | Returns the serial number of the date before or after a specified number of workdays |

WORKDAY.INTL | Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays. |

XIRR | Calculates the internal rate of return for a list of payments which take place on different dates. |

XNPV | Calculates the capital value (net present value)for a list of payments which take place on different dates. |

XOR | Returns true if an odd number of arguments evaluates to TRUE. |

YEAR | Returns the year of a date value as an integer. |

YEARFRAC | Returns the number of years (including fractional part) between two dates |

YIELD | Calculates the yield of a security. |

ZOIDBERG | Why not Zoidberg? |

Z.TEST | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. |

ZTEST | Calculates the probability of observing a z-statistic greater than the one computed based on a sample. |