Returns the number of periods for an investment to reach a specific value at a given rate..

PDURATION(rate, present_value, future_value)

Returns a range reference shifted a specified number of rows and columns from a starting cell ref...

OFFSET(cell_reference, offset_rows, offset_columns, [height], [width])

Rounds a number up to the nearest odd integer.

ODD(value)

Converts a signed octal number to signed hexadecimal format.

OCT2HEX(signed_octal_number, [significant_digits])

Converts a signed octal number to decimal format.

OCT2DEC(signed_octal_number)

Converts a signed octal number to signed binary format.

OCT2BIN(signed_octal_number, [significant_digits])

Calculates the net present value of an investment based on a series of periodic cash flows and a ...

NPV(discount, cashflow1, [cashflow2, ...])

Calculates the number of payment periods for an investment based on constant-amount periodic paym...

NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])

Returns the value of the inverse standard normal distribution function for a specified value.

NORMSINV(x)

Returns the value of the standard normal cumulative distribution function for a specified value.

NORMSDIST(x)

Returns the value of the inverse normal distribution function for a specified value, mean, and st...

NORMINV(x, mean, standard_deviation)

Returns the value of the normal distribution function (or normal cumulative distribution function...

NORMDIST(x, mean, standard_deviation, cumulative)

See NORMSINV

NORM.S.INV(x)

See NORMSDIST

NORM.S.DIST(x)

See NORMINV

NORM.INV(x, mean, standard_deviation)

See NORMDIST

NORM.DIST(x, mean, standard_deviation, cumulative)

Calculates the annual nominal interest rate given the effective rate and number of compounding pe...

NOMINAL(effective_rate, periods_per_year)

Returns the number of net working days between two provided days excluding specified weekend days...

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Returns the number of net working days between two provided days.

NETWORKDAYS(start_date, end_date, [holidays])

Calculates the probability of drawing a certain number of failures before a certain number of suc...

NEGBINOMDIST(num_failures, num_successes, prob_success)

See NEGBINOMDIST

NEGBINOM.DIST(num_failures, num_successes, prob_success)

Returns the "value not available" error, `#N/A`.

NA()

Returns the argument provided as a number.

N(value)

Returns a unit matrix of size dimension x dimension..

MUNIT(dimension)

Returns the product of two numbers. Equivalent to the `*` operator.

MULTIPLY(factor1, factor2)

Returns the factorial of the sum of values divided by the product of the values' factorials.

MULTINOMIAL(value1, value2)

See T.TEST.

TTEST(range1, range2, tails, type)

Truncates a number to a certain number of significant digits by omitting less significant digits.

TRUNC(value, [places])

Calculates the mean of a dataset excluding some proportion of data from the high and low ends of ...

TRIMMEAN(data, exclude_proportion)

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

Converts a provided numeric value to a text value.

TO_TEXT(value)

Converts a provided date/time, percentage, currency or other formatted numeric value to a pure nu...

TO_PURE_NUMBER(value)

Converts a provided number to a percentage.

TO_PERCENT(value)

Converts a provided number to a dollar value.

TO_DOLLARS(value)

Converts a provided number to a date.

TO_DATE(value)

See T.INV.2T

TINV(probability, degrees_freedom)

Converts a provided hour, minute, and second into a time.

TIME(hour, minute, second)

Combines the text from multiple strings and/or arrays, with a specifiable delimiter separating th...

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

Calculates the probability for Student's t-distribution with a given input (x).

TDIST(x, degrees_freedom, tails)

Calculates the yield of a US Treasury Bill based on price.

TBILLYIELD(settlement, maturity, price)

Calculates the price of a US Treasury Bill based on discount rate.

TBILLPRICE(settlement, maturity, discount)

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)