Comparisons of Microsoft Excel functions to those available in Anaplan.

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

 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.