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