Page 9 of 11
RATE
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])
RECEIVED
Calculates the amount received at maturity for an investment in fixed-income securities purchased...
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
REDUCE
Reduces an array to an accumulated result by application of a LAMBDA function to each value.
REDUCE(initial_value, array_or_range, LAMBDA)
REGEXEXTRACT
Extracts matching substrings according to a regular expression.
REGEXEXTRACT(text, regular_expression)
REGEXMATCH
Whether a piece of text matches a regular expression.
REGEXMATCH(text, regular_expression)
REGEXREPLACE
Replaces part of a text string with a different text string using regular expressions.
REGEXREPLACE(text, regular_expression, replacement)
REPLACE
Replaces part of a text string with a different text string.
REPLACE(text, position, length, new_text)
REPLACEB
Replaces part of a text string, based on a number of bytes, with a different text string..
REPLACEB(text, position, num_bytes, new_text)
REPT
Returns specified text repeated a number of times.
REPT(text_to_repeat, number_of_repetitions)
RIGHT
Returns a substring from the end of a specified string.
RIGHT(string, [number_of_characters])
RIGHTB
Returns the right portion of a string up to a certain number of bytes..
RIGHTB(string, num_of_bytes)
ROMAN
Formats a number in Roman numerals.
ROMAN(number, [rule_relaxation])
ROUND
Rounds a number to a certain number of decimal places according to standard rules.
ROUND(value, [places])
ROUNDDOWN
Rounds a number to a certain number of decimal places, always rounding down to the next valid inc...
ROUNDDOWN(value, [places])
ROUNDUP
Rounds a number to a certain number of decimal places, always rounding up to the next valid incre...
ROUNDUP(value, [places])
ROW
Returns the row number of a specified cell.
ROW([cell_reference])
ROWS
Returns the number of rows in a specified array or range.
ROWS(range)
RRI
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)
RSQ
Calculates the square of r, the Pearson product-moment correlation coefficient of a dataset.
RSQ(data_y, data_x)
SCAN
Scans an array and produces intermediate values by application of a LAMBDA function to each value...
SCAN(initial_value, array_or_range, LAMBDA)
SEARCH
Returns the position at which a string is first found within text.
SEARCH(search_for, text_to_search, [starting_at])
SEARCHB
Returns the position at which a string is first found within text counting each double-character ...
SEARCHB(search_for, text_to_search, [starting_at])
SEC
The SEC function returns the secant of an angle, measured in radians..
SEC(angle)
SECH
The SECH function returns the hyperbolic secant of an angle.
SECH(value)
SECOND
Returns the second component of a specific time, in numeric format.
SECOND(time)
SEQUENCE
Returns an array of sequential numbers, such as 1, 2, 3, 4..
SEQUENCE(rows, columns, start, step)
SERIESSUM
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)
SHEET
Returns the sheet number of the specified sheet or other reference.
SHEET([value])
SHEETS
Returns the total number of sheets in the spreadsheet.
SHEETS([reference])
SIGN
Given an input number, returns `-1` if it is negative, `1` if positive, and `0` if it is zero.
SIGN(value)
SIN
Returns the sine of an angle provided in radians.
SIN(angle)
SINH
Returns the hyperbolic sine of any real number.
SINH(value)
SKEW
Calculates the skewness of a dataset, which describes the symmetry of that dataset about the mean.
SKEW(value1, value2)
SKEW.P
Calculates the skewness of a dataset that represents the entire population..
SKEW.P(value1, value2)
SLN
Calculates the depreciation of an asset for one period using the straight-line method.
SLN(cost, salvage, life)
SLOPE
Calculates the slope of the line resulting from linear regression of a dataset.
SLOPE(data_y, data_x)
SMALL
Returns the nth smallest element from a data set, where n is user-defined.
SMALL(data, n)
SORT
Sorts the rows of a given array or range by the values in one or more columns.
SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2])
SORTN
Returns the first n items in a data set after performing a sort.
SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], ...)
SPARKLINE
Creates a miniature chart contained within a single cell.
SPARKLINE(data, [options])
SPLIT
Divides text around a specified character or string, and puts each fragment into a separate cell ...
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
SQRT
Returns the positive square root of a positive number.
SQRT(value)
SQRTPI
Returns the positive square root of the product of Pi and the given positive number.
SQRTPI(value)
STANDARDIZE
Calculates the normalized equivalent of a random variable given mean and standard deviation of th...
STANDARDIZE(value, mean, standard_deviation)
STDEV
Calculates the standard deviation based on a sample.
STDEV(value1, [value2, ...])
STDEV.P
See STDEVP
STDEV.P(value1, [value2, ...])
STDEV.S
See STDEV
STDEV.S(value1, [value2, ...])
STDEVA
Calculates the standard deviation based on a sample, setting text to the value `0`.
STDEVA(value1, value2)