Excel Functions

Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.

Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.

Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.

Search

RANK.AVG	Statistical		Returns the rank of a number in a list of numbers
RANK.EQ	Statistical		Returns the rank of a number in a list of numbers
RATE	Financial		Returns the interest rate per period of an annuity
RECEIVED	Financial		Returns the amount received at maturity for a fully invested security
REGISTER.ID	Add-in and Automation		Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
REPLACE – REPLACEB	Text		Replaces characters within text
REPT	Text		Repeats text a given number of times
RIGHT – RIGHTB	Text		Returns the rightmost characters from a text value
ROMAN	Math and trigonometry		Converts an arabic numeral to roman, as text
ROUND	Math and trigonometry		Rounds a number to a specified number of digits
ROUNDDOWN	Math and trigonometry		Rounds a number down, toward zero
ROUNDUP	Math and trigonometry		Rounds a number up, away from zero
ROW	Lookup and reference		Returns the row number of a reference
ROWS	Lookup and reference		Returns the number of rows in a reference
RRI	Financial		Returns an equivalent interest rate for the growth of an investment
RSQ	Statistical		Returns the square of the Pearson product moment correlation coefficient
RTD	Lookup and reference		Retrieves real-time data from a program that supports COM automation
SEARCH – SEARCHB	Text		Finds one text value within another (not case-sensitive)
SEC	Math and trigonometry		Returns the secant of an angle
SECH	Math and trigonometry		Returns the hyperbolic secant of an angle