Page 10 of 11
STDEVP
Calculates the standard deviation based on an entire population.
STDEVP(value1, value2)
STDEVPA
Calculates the standard deviation based on an entire population, setting text to the value `0`.
STDEVPA(value1, value2)
STEYX
Calculates the standard error of the predicted y-value for each x in the regression of a dataset.
STEYX(data_y, data_x)
SUBSTITUTE
Replaces existing text with new text in a string.
SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number])
SUBTOTAL
Returns a subtotal for a vertical range of cells using a specified aggregation function.
SUBTOTAL(function_code, range1, [range2, ...])
SUM
Returns the sum of a series of numbers and/or cells.
SUM(value1, [value2, ...])
SUMIF
Returns a conditional sum across a range.
SUMIF(range, criterion, [sum_range])
SUMIFS
Returns the sum of a range depending on multiple criteria.
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
SUMPRODUCT
Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.
SUMPRODUCT(array1, [array2, ...])
SUMSQ
Returns the sum of the squares of a series of numbers and/or cells.
SUMSQ(value1, [value2, ...])
SUMX2MY2
Calculates the sum of the differences of the squares of values in two arrays.
SUMX2MY2(array_x, array_y)
SUMX2PY2
Calculates the sum of the sums of the squares of values in two arrays.
SUMX2PY2(array_x, array_y)
SUMXMY2
Calculates the sum of the squares of differences of values in two arrays.
SUMXMY2(array_x, array_y)
SWITCH
Tests an expression against a list of cases and returns the corresponding value of the first matc...
SWITCH(expression, case1, value1, [default or case2, value2], …)
SYD
Calculates the depreciation of an asset for a specified period using the sum of years digits method.
SYD(cost, salvage, life, period)
T
Returns string arguments as text.
T(value)
T.DIST
Returns the right tailed Student distribution for a value x..
T.DIST(x, degrees_freedom, cumulative)
T.DIST.2T
Returns the two tailed Student distribution for a value x..
T.DIST.2T(x, degrees_freedom)
T.DIST.RT
Returns the right tailed Student distribution for a value x..
T.DIST.RT(x, degrees_freedom)
T.INV
Calculates the negative inverse of the one-tailed TDIST function.
T.INV(probability, degrees_freedom)
T.INV.2T
Calculates the inverse of the two-tailed TDIST function.
T.INV.2T(probability, degrees_freedom)
T.TEST
Returns the probability associated with Student's t-test. Determines whether two samples are like...
T.TEST(range1, range2, tails, type)
TAN
Returns the tangent of an angle provided in radians.
TAN(angle)
TANH
Returns the hyperbolic tangent of any real number.
TANH(value)
TBILLEQ
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.
TBILLEQ(settlement, maturity, discount)
TBILLPRICE
Calculates the price of a US Treasury Bill based on discount rate.
TBILLPRICE(settlement, maturity, discount)
TBILLYIELD
Calculates the yield of a US Treasury Bill based on price.
TBILLYIELD(settlement, maturity, price)
TDIST
Calculates the probability for Student's t-distribution with a given input (x).
TDIST(x, degrees_freedom, tails)
TEXT
Converts a number into text according to a specified format.
TEXT(number, format)
TEXTJOIN
Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating th...
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
TIME
Converts a provided hour, minute, and second into a time.
TIME(hour, minute, second)
TIMEVALUE
Returns the fraction of a 24-hour day the time represents.
TIMEVALUE(time_string)
TINV
See T.INV.2T
TINV(probability, degrees_freedom)
TOCOL
Transforms an array or range of cells into a single column.
TOCOL(array_or_range, [ignore], [scan_by_column])
TODAY
Returns the current date as a date value.
TODAY()
TOROW
Transforms an array or range of cells into a single row.
TOROW(array_or_range, [ignore], [scan_by_column])
TO_DATE
Converts a provided number to a date.
TO_DATE(value)
TO_DOLLARS
Converts a provided number to a dollar value.
TO_DOLLARS(value)
TO_PERCENT
Converts a provided number to a percentage.
TO_PERCENT(value)
TO_PURE_NUMBER
Converts a provided date/time, percentage, currency or other formatted numeric value to a pure nu...
TO_PURE_NUMBER(value)
TO_TEXT
Converts a provided numeric value to a text value.
TO_TEXT(value)
TRANSPOSE
Transposes the rows and columns of an array or range of cells.
TRANSPOSE(array_or_range)
TREND
Given partial data about a linear trend, fits an ideal linear trend using the least squares metho...
TREND(known_data_y, [known_data_x], [new_data_x], [b])
TRIM
Removes leading and trailing spaces in a specified string.
TRIM(text)
TRIMMEAN
Calculates the mean of a dataset excluding some proportion of data from the high and low ends of ...
TRIMMEAN(data, exclude_proportion)
TRUE
Returns the logical value `TRUE`.
TRUE()
TRUNC
Truncates a number to a certain number of significant digits by omitting less significant digits.
TRUNC(value, [places])
TTEST
See T.TEST.
TTEST(range1, range2, tails, type)