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 | 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. |
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. |
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. |
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. |
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 | 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. |
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 | 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. |
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 | 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. |
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. |