Alphabetical - R

RADIANSThe number of radians given the number of degrees.
RANDThe random number between zero and one (>=0 and <1).
RANDARRAY(2021) New. The array of random numbers between two values (>=min and <max).
RANDBETWEENThe random integer between two values (>=bottom and <=top).
RANK(RANK.EQ) The rank of a value in descending order (equal ranking).
RANK.AVGThe rank of a value in descending order (average ranking).
RANK.EQThe rank of a value in descending order (equal ranking).
RATEThe interest rate for a series of equal cash flows at regular intervals.
RECEIVEDThe amount received at the end when a security is held to maturity.
REDUCE(2021) New. The total value after reducing an array by applying a LAMBDA function.
REGEXEXTRACT(2024) Preview. The characters that match a regular expression.
REGEXREPLACE(2024) Preview. The text string after replacing characters that match a regular expression.
REGEXTEST(2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string.
REGISTER.ID(Removed in 2003) The result after running an Excel 4.0 Macro function.
REPLACEThe text string after replacing characters in a specific location.
REPTThe text string repeated a number of times.
RIGHTThe last or right most characters in a text string.
ROMANThe text string converting a binary number to a roman numeral.
ROUNDThe number rounded to a specified number of digits.
ROUNDDOWNThe number rounded down to a specified number of digits.
ROUNDUPThe number rounded up to a specified number of digits.
ROWThe row number of a cell reference.
ROWSThe number of rows in a cell range or reference.
RRIThe equivalent interest rate for the growth of an investment.
RSQThe square of pearson product moment correlation coefficient through data points in known y's and known x's.
RTDThe real time data from a program that supports COM.
RADIANS
The number of radians given the number of degrees.
RAND
The random number between zero and one (>=0 and <1).
RANDARRAY
(2021) New. The array of random numbers between two values (>=min and <max).
RANDBETWEEN
The random integer between two values (>=bottom and <=top).
RANK
(RANK.EQ) The rank of a value in descending order (equal ranking).
RANK.AVG
The rank of a value in descending order (average ranking).
RANK.EQ
The rank of a value in descending order (equal ranking).
RATE
The interest rate for a series of equal cash flows at regular intervals.
RECEIVED
The amount received at the end when a security is held to maturity.
REDUCE
(2021) New. The total value after reducing an array by applying a LAMBDA function.
REGEXEXTRACT
(2024) Preview. The characters that match a regular expression.
REGEXREPLACE
(2024) Preview. The text string after replacing characters that match a regular expression.
REGEXTEST
(2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string.
REGISTER.ID
(Removed in 2003) The result after running an Excel 4.0 Macro function.
REPLACE
The text string after replacing characters in a specific location.
REPT
The text string repeated a number of times.
RIGHT
The last or right most characters in a text string.
ROMAN
The text string converting a binary number to a roman numeral.
ROUND
The number rounded to a specified number of digits.
ROUNDDOWN
The number rounded down to a specified number of digits.
ROUNDUP
The number rounded up to a specified number of digits.
ROW
The row number of a cell reference.
ROWS
The number of rows in a cell range or reference.
RRI
The equivalent interest rate for the growth of an investment.
RSQ
The square of pearson product moment correlation coefficient through data points in known y's and known x's.
RTD
The real time data from a program that supports COM.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top