Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.

A B C D E F G H I L M N O P Q R S T U V W X Y

Excel functionExcel descriptionAnaplan solution
RADIANSConverts degrees into radians.There is no equivalent Anaplan function, but can be built using a calculation.
RANDReturns a random number that is greater than or equal to 0 and less than 1.There is no equivalent Anaplan function, but can be built using a calculation.
RANDBETWEENReturns a random number that is between a bottom and top range.There is no equivalent Anaplan function, but can be built using a calculation.
RANKReturns the rank of a number within a set of numbersUse the RANK function to order a set of values, and assign rankings from 1 to a specified ending rank.
RATEReturns the interest rate for an annuity.Use the RATE function to calculate a per period interest rate.
REPLACEReplaces a sequence of characters in a string with another set of characters.Use the FIND, LENGTH, LEFT, RIGHT, andnd & functions.
REPTReturns a repeated text value a specified number of times.There is no equivalent Anaplan function, but can be built using a calculation.
RIGHTExtracts a substring from a string starting from the right-most character.Use the RIGHT function.
ROMANConverts a number to a Roman numeral.There is no equivalent Anaplan function, but can be built using a calculation.
ROUNDReturns a number rounded to a specified number of digits.Use the ROUND function.
ROUNDDOWNReturns a number rounded down to a specified number of digits.Use the ROUND function.
ROUNDUPReturns a number rounded up to a specified number of digitsUse the ROUND function.
ROWReturns the row number of a cell reference.Use the ITEM function.
ROWSReturns the number of rows in a cell reference.There is no equivalent Anaplan function, but can be built using a calculation.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.