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

Returns the rank of a specified value in a dataset. If there is more than one entry of the same v...

RANK.EQ(value, data, [is_ascending])

Returns the rank of a specified value in a dataset. If there is more than one entry of the same v...

RANK.AVG(value, data, [is_ascending])

Generates an array of random numbers between 0 and 1..

RANDARRAY(rows, columns)

Converts an angle value in degrees to radians.

RADIANS(angle)

Returns one number divided by another.

QUOTIENT(dividend, divisor)

See QUARTILE

QUARTILE.INC(data, quartile_number)

Returns value nearest to a given quartile of a dataset, exclusive of 0 and 4..

QUARTILE.EXC(data, quartile_number)

Returns a value nearest to a specified quartile of a dataset.

QUARTILE(data, quartile_number)

Calculates the present value of an annuity investment based on constant-amount periodic payments ...

PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])

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)

Calculates the sum of the squares of differences of values in two arrays.

SUMXMY2(array_x, array_y)

Calculates the sum of the sums of the squares of values in two arrays.

SUMX2PY2(array_x, array_y)

Calculates the sum of the differences of the squares of values in two arrays.

SUMX2MY2(array_x, array_y)

Returns the sum of the squares of a series of numbers and/or cells.

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

Calculates the sum of the products of corresponding entries in two equal-sized arrays or ranges.

SUMPRODUCT(array1, [array2, ...])

Returns the sum of a range depending on multiple criteria.

SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])

Returns a subtotal for a vertical range of cells using a specified aggregation function.

SUBTOTAL(function_code, range1, [range2, ...])

Calculates the standard error of the predicted y-value for each x in the regression of a dataset.

STEYX(data_y, data_x)

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

STDEVPA(value1, value2)

Calculates the standard deviation based on an entire population.

STDEVP(value1, value2)

Calculates the standard deviation based on a sample, setting text to the value `0`.

STDEVA(value1, value2)

See STDEV

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

See STDEVP

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

Calculates the standard deviation based on a sample.

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

Calculates the normalized equivalent of a random variable given mean and standard deviation of th...

STANDARDIZE(value, mean, standard_deviation)

Returns the positive square root of the product of Pi and the given positive number.

SQRTPI(value)

Returns the positive square root of a positive number.

SQRT(value)

Returns the first n items in a data set after performing a sort.

SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)

Returns the nth smallest element from a data set, where n is user-defined.

SMALL(data, n)

Calculates the slope of the line resulting from linear regression of a dataset.

SLOPE(data_y, data_x)

Calculates the depreciation of an asset for one period using the straight-line method.

SLN(cost, salvage, life)

Calculates the skewness of a dataset that represents the entire population..

SKEW.P(value1, value2)

Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.

SKEW(value1, value2)

Returns the hyperbolic sine of any real number.

SINH(value)

Returns the sine of an angle provided in radians.

SIN(angle)

Converts a provided date string in a known format to a date value.

DATEVALUE(date_string)

Calculates the cumulative principal paid over a range of payment periods for an investment based ...

CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

Calculates the cumulative interest over a range of payment periods for an investment based on con...

CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)

The CSCH function returns the hyperbolic cosecant of any real number..

CSCH(value)