Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| RADIANS | Converts degrees into radians. | There is no equivalent Anaplan function, but can be built using a calculation. |
| RAND | Returns 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. |
| RANDBETWEEN | Returns a random number that is between a bottom and top range. | There is no equivalent Anaplan function, but can be built using a calculation. |
| RANK | Returns the rank of a number within a set of numbers | Use the RANK function to order a set of values, and assign rankings from 1 to a specified ending rank. |
| RATE | Returns the interest rate for an annuity. | Use the RATE function to calculate a per period interest rate. |
| REPLACE | Replaces a sequence of characters in a string with another set of characters. | Use the FIND, LENGTH, LEFT, RIGHT, andnd & functions. |
| REPT | Returns a repeated text value a specified number of times. | There is no equivalent Anaplan function, but can be built using a calculation. |
| RIGHT | Extracts a substring from a string starting from the right-most character. | Use the RIGHT function. |
| ROMAN | Converts a number to a Roman numeral. | There is no equivalent Anaplan function, but can be built using a calculation. |
| ROUND | Returns a number rounded to a specified number of digits. | Use the ROUND function. |
| ROUNDDOWN | Returns a number rounded down to a specified number of digits. | Use the ROUND function. |
| ROUNDUP | Returns a number rounded up to a specified number of digits | Use the ROUND function. |
| ROW | Returns the row number of a cell reference. | Use the ITEM function. |
| ROWS | Returns the number of rows in a cell reference. | There is no equivalent Anaplan function, but can be built using a calculation. |
