Calculator Component Formulas

The Calculator component processes data, performs functions, and executes calculations. Formulas in the Calculator component match those in Excel.

Here are the top 20 Most Frequently Used Formulas:

Function

Definition

CONCATENATE

Joins text items together into a single text item.

COUNT

Tallies the number of inputs.

COUNTA

Tallies both text and/or number inputs.

COUNTBLANK

Tallies the number of blank inputs.

DATEVALUE

Converts date string to an Excel date called a serial number. This represents the date as the number of days since January 1, 1900.

FIND

Locates specified text within other text (case-sensitive).

IF(AND(OR))

Customizes outputs based on defined criteria. For example, if this is true, then this will happen, or else that will happen.

INT

Rounds an input number down to the nearest integer.

LEFT

Calculates the specified number of characters starting at the left.

LEN

Counts the number of characters or length for text.

LOWER

Transforms text to all lower case.

MATCH

Searches for a specified item in a reference or array.

MEDIAN

Calculates the middle value of the inputs.

MIN

Identifies the lowest input number.

MULTIPLY

Calculates the product of the inputs.

RIGHT

Returns the specified number of characters starting at the right.

SUM

Calculates the addition of the inputs.

TEXTJOIN

Joins text together from multiple ranges or strings. You can specify a delimiter between joined text values. Empty values can be ignored.

TIP  To learn more about TEXTJOIN, search TEXTJOIN Formula in our In-Product Help.

UPPER

Transforms text to all upper case.

YEARFRAC

Calculates the difference in years between two dates as a fraction.

 

Here is a full list of the formulas you can use in the Calculator component. The top 20 most frequently used formulas are not repeated in this list.

Function

Definition

ACCRINT

Calculates accrued interest for a security that pays periodic interest.

ACOS

Returns the arccosine of a number or angle of a cosign.

ACOSH

Returns the inverse hyperbolic cosine of a number.

ACOT

Returns the arccotangent or arc cotangent of a number. This is the angle, measured in radians, that has a cotangent equal to the given number.

ACOTH

Returns the inverse hyperbolic arccotangent of a number.

ADD

Returns a value by combining specified values.

AGGREGATE

Groups multiple values in a list or database into a single value.

ALPHARANGE

Returns the current alpha or transparency value between 0.0 (fully transparent) and 1.0 (no transparency).

AND

Used to determine whether all conditions are TRUE.

ARABIC

Converts Roman numbers to Arabic numbers ( 0, 1, 2, 3, 4, 5, 6, 7, 8 and 9).

ARGS2ARRAY

Creates an array from individual fields or an object. Useful in a data workflow for converting an object to a single-row table. (=ARGS2ARRAY(A) in a formula).

ASIN

Returns the arcsine of a number.

ASINH

Returns the inverse hyperbolic sine of a number.

ATAN

Returns the arctangent of a number.

ATAN2

Returns the arctangent from x- and y-coordinates.

ATANH

Calculates the inverse hyperbolic tangent of a number.

AVEDEV

Returns the average deviation of a set of values.

AVERAGE

Returns the arithmetic mean of the numbers provided.

AVERAGEA

Returns the arithmetic mean of the numbers, text, and logical values provided.

AVERAGEIF

Returns the arithmetic mean of the cells in a range that meet a given criteria.

AVERAGEIFS

Returns the arithmetic mean of the cells in a range that meet a given criteria.

BASE

Returns a text representation by converting a number into a supplied base (radix).

BESSELI

Returns the modified Bessel function In(x).

BESSELJ

Returns the Bessel function Jn(x).

BESSELK

Returns the modified Bessel function Kn(x).

BESSELY

Returns the Bessel function Yn(x).

BETA.DIST

Returns the beta cumulative distribution function. It's used to study variation in the percentage of something across samples.

BETA.INV

Returns the inverse of the beta cumulative distribution function. It's used to study variation in the percentage of something across samples.

BETADIST

Returns the beta cumulative distribution function. It's used to study variation in the percentage of something across samples.

BETAINV

Returns the inverse of the beta cumulative distribution function. It's used to study variation in the percentage of something across samples.

BIN2DEC

Converts a binary number to decimal.

BIN2HEX

Converts a binary number to hexadecimal.

BIN2OCT

Converts a binary number to octal.

BINOM.DIST

Returns the individual term binomial distribution probability. Use this when the outcomes of a test are only: success or failure.

BINOM.DIST.RANGE

Returns the individual term binomial distribution probability. Use this when the outcomes of a test are only: success or failure.

BINOM.INV

Returns the smallest number of successes where the binomal distribution is less than or equal to a particular value. This shows the probability of a specific number of successes from a specific number of tests.

BINOMDIST

Calculates the probability of getting less than or equal to a particular value in a binomial distribution.

BITAND

Returns a decimal number representing the 'Bitwise And' of two numbers.

BITLSHIFT

Returns a value number shifted left by the number of bits specified.

BITOR

Returns a decimal number representing the 'Bitwise Or' of two numbers.

BITRSHIFT

Returns a value number shifted right by the number of bits specified.

BITXOR

Returns a decimal number based on the comparison of two numbers. It is an 'Exclusive Or'. If both digits at each position are not equal, it returns a 1 for that position. If both digits at each position are equal, it returns zero for that position.

CEILING

Rounds real a number to the nearest integer greater than or equal to the real number.

CEILINGMATH

Rounds real a number to the nearest integer greater than or equal to the real number.

CEILINGPRECISE

Rounds real a number to the nearest integer greater than or equal to the real number. Rounding happens regardless of the sign of the number.

CHAR

Returns a character specified by the code number. For example, CHAR (10 returns a line break on Windows, CHAR(13) returns a line break on the Mac.

CHISQ.DIST

Calculates the chi-squared distribution. It shows the variation in the percentage accross samples.

CHISQ.DIST.RT

Calculates the right-tailed or upper probability of the chi-squared distribution. it is used to compare and observe expected values.

CHISQ.INV

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

CHISQ.INV.RT

Returns the inverse of the right-tailed probability of the chi-squared distribution.

CHOOSE

Returns a value from a list of values.

CLEAN

Returns text with all line breaks and non-printable characters removed.

CODE

Returns a numeric code for a specified character in a text string.

COLUMN

Returns the column number of a reference.

COLUMNS

Returns the number of columns in a reference.

COMBIN

Returns the number of combinations for a set of objects.

COMBINA

Returns the number of combinations for a set of objects and includes repetitions.

COMPLEX

Converts coefficients (real and imaginary) into a complex number.

CONFIDENCE

Returns the confidence interval for a probability and sample size.

CONFIDENCE.NORM

Uses the normal distribution to return the confidence interval for a population mean.

CONFIDENCE.T

Uses a student's t distribution to return the confidence interval for a population mean.

CONVERT

Converts a number from one data type to another.

CORREL

Returns the correlation coefficient or relationship between two data sets.

COS

Returns the cosine of a number.

COSH

Returns the hyperbolic cosine of a number.

COT

Returns the hyperbolic cosine of a number.

COTH

Returns the cotangent of an angle.

COUNTIF

Counts the number of cells for the specified criteria.

COUNTIFS

Counts the number of cells meeting multiple specified criteria.

COUNTIN

Counts how many times a specified value is in an array.

COUNTUNIQUE

Counts the number of unique values within a list of specified values and ranges.

COVARIANCE.P

Returns covariance, the average of the products of paired deviations.

COVARIANCE.S

Returns the sample covariance, the average of the products deviations for each data point pair in two data sets.

CSC

Returns the cosecant of an angle.

CSCH

Returns the hyperbolic cosecant of an angle.

CUMIPMT

Returns the cumulative interest paid between a start period and an end period.

CUMPRINC

Returns the cumulative principal paid between a start period and an end period.

DATE

Calculates the serial number of a particular date. This represents the date as the number of days since January 1, 1900.

DATEADD

Adds or subtracts an interval from a date.

DATEFORMAT

Converts a datetime value to a string using a specified format.

DAY

Converts a serial number to a day of the month (1 to 31).

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 based on the fixed-declining balance method.

DDB

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

DEC2BIN

Converts a decimal number to binary.

DEC2HEX

Converts a decimal number to hexadecimal.

DEC2OCT

Converts a decimal number to octal.

DECIMAL

Converts a text number into a decimal number.

DEGREES

Converts radians to degrees.

DELTA

Compares the difference between two values.

DEVSQ

Returns the sum of squares of deviations for a set of data.

DIVIDE

Calculates one value divided by a second value.

DOLLAR

Converts a number to text, using the currency format ($#,##0.00).

DOLLARDE

Converts a dollar price fraction into a decimal.

DOLLARFR

Converts a dollar price fraction into a decimal.

E

Returns a value that is equal to the specified value.

EDATE

Returns a date a set number of months in the past or future from the specified date.

EFFECT

Returns the effective annual interest rate.

EOMONTH

Returns the serial number of the last day of the month after adding a specified number of months to a date.

EQ

Returns a rank for a number against a list of other values.

ERF

Returns the error function.

ERFC

Returns the complementary error function.

EVEN

Rounds a number to the nearest even integer.

EXACT

Checks to see if two text values are identical.

EXP

Returns constant e raised to the power of a given number. Constant e relates to exponential growth and decay. Its value is approximately 2.71828.

EXPON.DIST

Returns the exponential distribution.

EXPONDIST

Returns the exponential distribution.

F.DIST

Returns the F probability distribution. Use this to determine whether two data sets have different degrees of diversity.

F.DIST.RT

Returns the F probability distribution. Use this to determine whether two data sets have different degrees of diversity.

F.INV

Returns the inverse of the F probability distribution.

F.INV.RT

Returns the inverse of the F probability distribution.

FACT

Counts the number of possible arrangements for a group of items.

FACTDOUBLE

Returns the double factorial of a number.

FALSE

Returns the value TRUE.

FDIST

Calculates the (right-tailed) F Probability Distribution, which measures the degree of diversity between two data sets.

FDISTRT

Calculates the (right-tailed) F Probability Distribution, which measures the degree of diversity between two data sets.

FINV

Returns the opposite of the F probability distribution.

FINVRT

Returns the opposite of the F probability distribution.

FISHER

Returns the Fisher transformation for the supplied value. Use this to test hypotheses on the correlation coefficient.

FISHERINV

Returns the inverse of the Fisher transformation.

FIXED

Converts a number to text with a fixed number of decimals.

FLATTEN

Flattens a nested array. See Lodash flatten: https://lodash.com/docs/4.17.15#flatten.

FLOOR

Rounds real a number to the nearest integer less than or equal to the real number.

FORECAST

Returns a predicted future value based on the existing values.

FREQUENCY

Calculates how often values occur within the ranges specified.

FV

Returns the future value of an investment.

FVSCHEDULE

Returns the future value of an investment after applying a series of given interest rates.

GAMMA

Returns the Gamma function value.

GAMMA.DIST

Returns the gamma distribution.

GAMMA.INV

Returns the opposite of the gamma cumulative distribution.

GAMMADIST

Returns the gamma distribution.

GAMMAINV

Returns the opposite of the gamma cumulative distribution.

GAMMALN

Calculates the natural logarithm of the gamma function, Γ(x).

GAMMALN.PRECISE

Calculates the natural logarithm of the gamma function, Γ(x).

GAUSS

Returns the number of standard deviations from the mean.

GCD

Returns the greatest common divisor of two or more integers.

GEOMEAN

Calculates the geometric mean for a set of numbers.

GESTEP

Tests whether a specified number is greater than a specified step size.

GET

Gets a path within an object: See lodash GET: https://lodash.com/docs/4.17.15#get.

GROUPBY

Groups rows into a set of summary rows and returns one row for each group.

GROWTH

Calculates predicted exponential growth using the supplied data.

GTE

Returns the Generalized Turnbull's Estimator.

HARMEAN

Calculates the harmonic mean for a set of values.

HEX2BIN

Converts hexadecimal (Base16) number to a binary (Base 2) number.

HEX2DEC

Converts hexadecimal (Base 16) number to decimal number.

HEX2OCT

Converts hexadecimal (Base 16) number to octal (Base 8) number.

HOUR

Converts a serial number to an hour format (9:00 PM).

HTML2TEXT

Converts an HTML string into plain text.

HYPGEOM.DIST

Returns the hypergeometric distribution or probability of a given number of sample successes.

HYPGEOMDIST

Returns the hypergeometric distribution or probability of a given number of sample successes.

IF

Lets you compare a value and an expectation by testing for the condition.

IMABS

Used to get the absolute value of a complex number.

IMAGINARY

Used to get the imaginary coefficient of a complex number.

IMA

Returns the argument theta, an angle for a complex number expressed in radians.

IMCONJUGATE

Used to get the complex conjugate of a complex number.

IMCOS

Returns the cosine of a supplied complex number.

IMCOSH

Calculates the hyperbolic cosine of a complex number.

IMCOT

Returns the cotangent of a supplied complex number.

IMCSC

Used to get the cosecant of a supplied complex number.

IMCSCH

Returns the hyperbolic cosecant of a supplied complex number.

IMDIV

Returns the complex exponential of a complex number.

IMEXP

Returns the complex exponential of a complex number.

IMLN

Returns the natural logarithm of a supplied complex number.

IMLOG2

Returns the base-2 logarithm of a supplied complex number.

IMLOG10

Returns the common (base-10) logarithm of a supplied complex number.

IMPOWER

Returns a complex number raised to a specified power.

IMPRODUCT

Used to get the product of one or more complex numbers.

IMREAL

Used to get the real coefficient of a complex number.

IMSEC

Returns the secant of a complex number.

IMSECH

Used to get the hyperbolic secant of a supplied complex number.

IMSIN

Returns the sine of a supplied complex number.

IMSINH

Returns the hyperbolic sine of a supplied complex number.

IMSQRT

Used to get the square root of a complex number.

IMSUB

Returns the difference between two complex numbers.

IMSUM

Returns the sum of two or more complex numbers.

IMTAN

Returns the tangent of a complex number.

INITIAL

Returns the output value when the input is 0.

INTERCEPT

Used to get the intercept of the linear regression line.

INTERVAL

specifies the intervals on the horizontal axis of a chart.

IPMT

Calculates the interest portion of a loan or investment based on the principle payment and payment period.

IRR

Calculates the internal rate of return, the expected compound annual rate of return to be earned on an investment.

ISBINARY

Returns TRUE if the value is a binary type.

ISBLANK

Returns TRUE if the value is blank.

ISEVEN

Returns TRUE if the number is even.

ISLOGICAL

Returns TRUE if the value is a logical value.

ISNONTEXT

Returns TRUE if the value is text.

ISNUMBER

Returns TRUE if the value is a number.

ISODD

Returns TRUE if the number is odd.

ISOWEEKNUM

Returns a number for the week number of the year for a given date.

ISPMT

Calculates interest paid during a specific period of a loan or investment.

ISTEXT

Returns TRUE if the value is text.

JOIN

Joins elements separated by a delimiter.

JOINKEYVALUE

This value links rows between tables.

JOINKEYVALUEARRAY

Merges elements of one or more arrays so that the values of one are appended to the end of the previous one.

KEYSARRAY

Returns a new array iterator object which contains a key for each item in the array.

KURT

Calculates the kurtosis (peakedness or flatness of a distribution) of a data set.

LABELVALUEARRAY

Assigns labels to values in an array.

LARGE

Returns the k-th largest value in a data set.

LCM

Returns the least common multiple of the supplied numbers.

LINEST

Returns an array describing a linear trend.

LN

Returns the natural logarithm of a number.

LODASH

JavaScript library containing utility functions for programming.

LOG

Returns the logarithm of a number to a specified base.

LOG10

Returns the base-10 logarithm of a number.

LOGEST

Returns an array of the exponential curve based on supplied data.

LOGNORM.DIST

Returns the cumulative lognormal distribution. Use this to analyze data that has been transformed by a logarithm.

LOGNORM.INV

Returns the inverse of the lognormal cumulative distribution.

LOGNORMDIST

Returns the cumulative lognormal distribution. Use this to analyze data that has been transformed by a logarithm.

LOGNORMINV

Returns the inverse of the lognormal cumulative distribution.

LT

Returns a value that is less than the specified value.

LTE

Calculates whether a value is less than or equal to the specified value.

MAX

Returns the largest of the numbers provided.

MAXA

Returns the largest of the numbers provided, including numbers, text, and logical values.

MID

Returns a number of characters from a text string starting at the position you specify.

MINA

Returns the smallest of the numbers provided, including numbers, text, and logical values.

MINUS

Subtracts one or more values from a specific value.

MINUTE

Converts a serial number to a minute.

MIRR

Considers the cost of an investment and the interest received on reinvestment of cast to determine the modified internal rate of return for periodic cash flows.

MOD

Returns the remainder after a number is divided by a divisor.

MODE.MULT

Returns a vertical array of the most repetitive values in an array or range of data.

MODE.SNGL

Returns the value that occurs most frequently in a data set.

MODEMULT

Returns a vertical array of the most repetitive values in an array or range of data.

MODESNGL

Returns the value that occurs most frequently in a data set.

MOMENT

JavaScript date library for parsing, validating, formatting, and manipulating dates.

MONTH

Converts a serial number to a month or number 1-12.

MROUND

Returns a number, rounded up, away from zero.

MULTINOMIAL

Returns the multinomial probability distribution of a set of numbers.

NE

Calculates whether a value is not equal to the specified value.

NEGBINOM.DIST

Returns the probability of receiving less than or equal to a particular value in a negative binomial distribution.

NEGBINOMDIST

Returns the probability of receiving less than or equal to a particular value in a negative binomial distribution.

NETWORKDAYS

Returns the number of whole workdays between two dates.

NOMINAL

Returns the annual nominal interest rate.

NORM.DIST

Returns the normal distribution for the specified mean and standard deviation.

NORM.INV

Calculates the inverse of the standard normal cumulative distribution for a number.

NORM.S.DIST

Returns the normal distribution for the specified mean and standard deviation.

NORM.S.INV

Calculates the inverse of the standard normal cumulative distribution for a number.

NORMDIST

Returns the normal distribution for the specified mean and standard deviation.

NORMINV

Calculates the inverse of the standard normal cumulative distribution for a number.

NORMSDIST

Returns the normal distribution for the specified mean and standard deviation.

NORMSINV

Returns the inverse of the cumulative standardized normal distribution.

NOT

Used to determine whether a condition is FALSE.

NOW

Returns the serial number of the current date and time.

NPER

Returns the number of periods for a loan or investment.

NPV

Returns the net present value of an investment using a discount rate and a series of periodic cash flows.

NUMBERS

Converts text to a number indicating group separators and the decimal.

NUMERAL

Converts text to a number.

OCT2BIN

Converts an octal number to binary.

OCT2DEC

Converts an octal number to decimal.

OCT2HEX

Converts an octal number to hexadecimal.

ODD

Rounds a number to the nearest odd integer.

OR

Used to determine whether only one condition is TRUE.

PDURATION

Returns the number of periods needed for an investment to reach a specified amount.

PEARSON

Returns the Pearson product moment correlation coefficient. It shows how strongly the two variables correlate.

PERCENTILEEXC

Calculates the k-th percentile of values in a range, where k is 0 to 1.

PERCENTILEINC

Calculates the k-th percentile of values in a range, where k is 0 to 1.

PERCENTRANKEXC

Returns the rank of a value in a data set as a percentage indicating how many values are less than or equal to the value.

PERCENTRANKINC

Returns the rank of a value in a data set as a percentage indicating how many values are less than or equal to the value.

PERMUT

Returns the number of permutations of a given number of objects.

PERMUTATIONA

Returns the number of permutations of a given number of objects with repetitions.

PHI

Returns the value of the density function for a standard normal distribution.

PHONENUMBER

Converts letters to numbers and numbers to letters on a telephone keypad.

PI

Returns the value of pi.

PMT

Returns the periodic payment for a loan or annuity.

POISSON.DIST

Returns the Poisson distribution. This is the number of events occurring within a given time interval.

POISSONDIST

Returns the Poisson distribution. This is the number of events occurring within a given time interval.

POW

Returns the result of a number raised to the base power.

POWER

Returns the result of a given number raised to a power.

PPMT

Returns the principal portion of a loan payment for a given period.

PROB

Returns the probability that values in a range are between a lower and upper limit.

PRODUCT

Multiplies its values.

PROPER

Sets the first letter in each word text and of a text value and the rest to lowercase.

PV

Calculates the present value of a loan or investment.

QUARTILE.EXC

Returns the quartile of a data set, based on percentile values from 0 to 1, exclusive.

QUARTILE.INC

Returns the quartile for a data set.

QUARTILEEXC

Returns the quartile of a data set, based on percentile values from 0 to 1, exclusive.

QUARTILEINC

Returns the quartile for a data set.

QUOTIENT

Returns the integer portion of a division.

RADIANS

Converts degrees to radians.

RAND

Returns a random number equal or greater to 0 and less than 1.

RANDBETWEEN

Returns a random number between two numbers, returning a different random number each time.

RANK.AVG

Returns the rank of a number against a list of numbers.

RANK.EQ

Returns the rank of a number against a list of numbers, duplicate numbers receive the same rank.

RANKAVG

Returns the rank of a number against a list of numbers.

RANKEQ

Returns the rank of a number against a list of numbers, duplicate numbers receive the same rank.

RATE

Returns the interest rate on a loan per period.

REFERENCE

Refers to a specific cell at a fixed row and column.

REGEXEXTRACT

Extracts matching text strings based on a regular expression.

REGEXMATCH

Determines whether part of a text string matches a regular expression.

REGEXREPLACE

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

REPLACE

Replaces characters within text.

REPT

Repeats text a given number of times.

REST

Passes an indefinite number of parameters to a function and accesses them in an array.

ROMAN

Converts a number to a Roman numeral.

ROUND

Rounds a number to a specified number of digits.

ROUNDDOWN

Rounds a number down, toward zero.

ROUNDUP

Rounds a number down, away from zero.

ROW

Returns the row number of a reference.

ROWS

Returns the number of rows of a reference.

RRI

Returns an equivalent interest rate for the growth of an investment.

RSQ

Returns the square of the Pearson product moment correlation coefficient.

SEARCH

Locates specified text within other text (not case-sensitive).

SEC

Returns the secant of an angle.

SECH

Returns the hyperbolic secant of an angle.

SECOND

Converts a serial number to a second of time (0-59).

SERIESSUM

Returns the sum of a power series.

SIGN

Returns the sign of a real number.

SIN

Returns the sine of the given angle.

SINH

Returns the hyperbolic sine of a number.

SKEW

Returns the skewness of a distribution for a dataset.

SKEW.P

Returns the skewness of a distribution for a data set based on a population. It is a characterization of the degree of asymmetry of a distribution around its mean.

SKEWP

Returns the skewness of a distribution for a data set based on a population. It is a characterization of the degree of asymmetry of a distribution around its mean.

SLN

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

SLOPE

Returns the slope of the linear regression line.

SMALL

Returns the smallest value in a list.

SPLIT

Divides text by a specified number of characters or string and puts each part in a separate cell.

SQRT

Returns a positive square root.

SQRTPI

Returns the square root of (number * pi).

STANDARDIZE

Returns a normalized value.

STDEV.P

Calculates standard deviation based on the whole population.

STDEV.S

Estimates standard deviation based on a sample.

STDEVA

Estimates standard deviation based on a sample of numbers, text, and logical values.

STDEVP

Calculates standard deviation based on the whole population.

STDEVPA

Calculates standard deviation based on the whole population using including numbers, text, and logical values.

STDEVS

Uses a sample to calculate the standard deviation.

STEYX

Calculates the standard error or the error amount in the prediction of y for an x.

STRINGIFY

Converts a JavaScript object or value to a JSON string.

SUBSTITUTE

Substitutes new text for old text in a text string.

SUBTOTAL

Returns a subtotal for a list or database.

SUMIF

Adds the cells specified by a given criteria.

SUMIFS

Adds the contents of cells in a range that meet multiple criteria.

SUMPRODUCT

Returns the sum of the products of corresponding array components.

SUMSQ

Returns the sum of the squares for a series of values.

SUMX2MY2

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

SUMX2PY2

Calculates the sum of squares and returns the sum of the squares of corresponding items.

SUMXMY2

Returns the sum of squares of differences of corresponding values in two arrays.

SWITCH

Returns the first matching value when comparing one value against a list of values.

SYD

Returns the sum-of-years depreciation for an asset for a specified period.

T

Returns a value for referenced text.

T.DIST

Returns the Percentage Points (probability) for the Student t-distribution.

T.DIST.RT

Returns the Student's t-distribution.

T.DIST.2T

Returns the Percentage Points (probability) for the Student t-distribution.

T.INV

Returns the left-tailed inverse of the Student's t-distribution.

T.INV.2T

Returns the two-tailed inverse of the Student's t-distribution.

TAN

Returns the tangent of a number.

TANH

Returns the hyperbolic tangent of a number.

TBILLEQ

Returns the bond-equivalent for a Treasury bill.

TBILLPRICE

Returns the price per $100 of face value for a Treasury bill.

TBILLYIELD

Returns the yield for a Treasury bill.

TDIST

Returns the Percentage Points (probability) for the Student t-distribution.

TDIST2T

Returns the Student's t-distribution.

TDISTRT

Returns the right-tailed Student's t-distribution.

TEXT

Converts a number to text.

TIME

Converts a specific time to a serial number.

TIMEVALUE

Converts a specific time in text format to a serial number.

TIMEVALUE

Converts a specific time in text format to a serial number.

TINV

Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.

TINV2T

Returns the inverse of the Student's t-distribution.

TODAY

Returns the serial number of today's date.

TRANSPOSE

Converts a range from vertical to a horizontal or horizontal to vertical.

TREND

Statistical: Returns values along a linear trend.

TRIM

Removes spaces from the beginning and end of a text string.

TRIMMEAN

Returns the mean by excluding data points from the top and bottom of the data set. Only interior data points are used.

TRUE

Returns the value TRUE.

TRUNC

Truncates a number to an integer.

UNICHAR

Returns the Unicode character that is referenced by the given numeric value.

UNICODE

Returns the number (code point) that corresponds to the first character of the text.

UNIQUE

Returns a list of distinct values in a list or range.

VALUE

Converts text to a value.

VAR.P

Calculates variance based on the entire population.

VAR.S

Estimates variance based on a sample.

VARA

Estimates variance based on a sample including numbers, text, and logical value.

VARP

Calculates variance based on the entire population.

VARPA

Calculates variance of a population-based on numbers, text, and logical values.

VARS

Returns the __dict__ attribute of an object. The dictionary containing the object's changeable attributes.

WEEKDAY

Converts a serial number to a day of the week.

WEEKNUM

Converts a serial number to a number indicating where the week falls with a year.

WEIBULL.DIST

Calculates variance based on the entire population, including numbers, text, and logical values

WEIBULLDIST

Returns the Weibull distribution.

WORDWRAP

Wraps a string to new lines after a specified number of characters.

WORDWRAPARRAY

Wraps a text string at a specified number of characters using a string break.

WORKDAY

Returns a serial number for a date that is a specified number of working days in the future or past.

XIRR

Returns the internal rate of return for a schedule of cash flows that are not periodic.

XNPV

Calculates the net present value for a schedule of cash flows that are not periodic using a discount rate.

XOR

Performs an exclusive OR. With two logical statements, it returns TRUE if either statement is TRUE. It returns FALSE if both or only one is TRUE.

YEAR

Converts a serial number to a year. Serial Numbers represent the date as the number of days since January 1, 1900.