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.

Calculator Component Formulas

Feedback

Sorry about that

Great!

Looking for more help?