Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate.

TBILLEQ(settlement, maturity, discount)

Returns the hyperbolic tangent of any real number.

TANH(value)

Returns the tangent of an angle provided in radians.

TAN(angle)

Returns the probability associated with Student's t-test. Determines whether two samples are like...

T.TEST(range1, range2, tails, type)

Calculates the inverse of the two-tailed TDIST function.

T.INV.2T(probability, degrees_freedom)

Calculates the negative inverse of the one-tailed TDIST function.

T.INV(probability, degrees_freedom)

Returns the right tailed Student distribution for a value x..

T.DIST.RT(x, degrees_freedom)

Returns the two tailed Student distribution for a value x..

T.DIST.2T(x, degrees_freedom)

Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.

SIGN(value)

See Z.TEST.

ZTEST(data, value, [standard_deviation])

Returns the one-tailed P-value of a Z-test with standard distribution..

Z.TEST(data, value, [standard_deviation])

Calculates the annual yield of a security paying interest at maturity, based on price.

YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])

Calculates the annual yield of a discount (non-interest-bearing) security, based on price.

YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])

Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, b...

YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])

Returns the number of years, including fractional years, between two dates using a specified day ...

YEARFRAC(start_date, end_date, [day_count_convention])

The XOR function performs an exclusive or of 2 numbers that returns a 1 if the numbers are differ...

XOR(logical_expression1, [logical_expression2, ...])

Calculates the net present value of an investment based on a specified series of potentially irre...

XNPV(discount, cashflow_amounts, cashflow_dates)

Returns the values in the result range based on the position where a match was found in the looku...

XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])

Calculates the internal rate of return of an investment based on a specified series of potentiall...

XIRR(cashflow_amounts, cashflow_dates, [rate_guess])

Wraps a row or column of cells into a new array by filling across each row after a specified numb...

WRAPROWS(range, wrap_count, [pad_with])

Wraps a row or column of cells into a new array by filling down each column after a specified num...

WRAPCOLS(range, wrap_count, [pad_with])

Calculates the date after a specified number of workdays excluding specified weekend days and hol...

WORKDAY.INTL(start_date, num_days, [weekend], [holidays])

See WEIBULL

WEIBULL.DIST(x, shape, scale, cumulative)

Returns the value of the Weibull distribution function (or Weibull cumulative distribution functi...

WEIBULL(x, shape, scale, cumulative)

Returns a number representing the week of the year where the provided date falls.

WEEKNUM(date, [type])

Returns the depreciation of an asset for a particular period (or partial period)..

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])

Calculates the variance based on an entire population, setting text to the value `0`.

VARPA(value1, value2,...)

Calculates the variance based on an entire population.

VARP(value1, value2)

Calculates an estimate of variance based on a sample, setting text to the value `0`.

VARA(value1, value2)

See VAR

VAR.S(value1, [value2, ...])

See VARP

VAR.P(value1, [value2, ...])

Calculates the variance based on a sample.

VAR(value1, [value2, ...])

Returns a specified number, unchanged.

UPLUS(value)

Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the...

UNIQUE(range, by_column, exactly_once)

Returns the decimal Unicode value of the first character of the text..

UNICODE(text)

Returns the Unicode character for a number..

UNICHAR(number)

Returns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.

UNARY_PERCENT(percentage)

Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + ... + aix(n+(i-1)...

SERIESSUM(x, n, m, a)

Returns the second component of a specific time, in numeric format.

SECOND(time)

The SECH function returns the hyperbolic secant of an angle.

SECH(value)

The SEC function returns the secant of an angle, measured in radians..

SEC(angle)

Returns the total number of sheets in the spreadsheet.

SHEETS([reference])

Returns the sheet number of the specified sheet or other reference.

SHEET([value])

Returns the position at which a string is first found within text counting each double-character ...

SEARCHB(search_for, text_to_search, [starting_at])

Scans an array and produces intermediate values by application of a LAMBDA function to each value...

SCAN(initial_value, array_or_range, LAMBDA)

Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.

RSQ(data_y, data_x)

Returns the interest rate needed for an investment to reach a specific value within a given numbe...

RRI(number_of_periods, present_value, future_value)

Returns the number of rows in a specified array or range.

ROWS(range)