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

T.DIST.2T(x, degrees_freedom)

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

T.DIST(x, degrees_freedom, cumulative)

Returns string arguments as text.

T(value)

Calculates the depreciation of an asset for a specified period using the sum of years digits method.

SYD(cost, salvage, life, period)

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])

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)

Returns a number with the sign reversed.

UMINUS(value)

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)

Formats a number in Roman numerals.

ROMAN(number, [rule_relaxation])

Returns the right portion of a string up to a certain number of bytes..

RIGHTB(string, num_of_bytes)

Replaces part of a text string, based on a number of bytes, with a different text string..

REPLACEB(text, position, num_bytes, new_text)

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

REPLACE(text, position, length, new_text)

Reduces an array to an accumulated result by application of a LAMBDA function to each value.

REDUCE(initial_value, array_or_range, LAMBDA)

Calculates the amount received at maturity for an investment in fixed-income securities purchased...

RECEIVED(settlement, maturity, investment, discount, [day_count_convention])

Calculates the interest rate of an annuity investment based on constant-amount periodic payments ...

RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])