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. |