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 PERCENTILE Returns the nth percentile from a set of values. There is no equivalent Anaplan function, but can be built using a calculation. PERCENTRANK Returns the rank of a value in a set of values as a percentage of the set. There is no equivalent Anaplan function, but can be built using a calculation. Percentile = (number of values below X) + 0.5)/total number of values*100 PERMUT Returns the number of permutations for a specified number of items. Use the POWER function for permutations where repetition is allowed, where: x = the number of items n = the number of permutations PI Returns the mathematical constant called pi. There is no equivalent Anaplan function, but can be built using a calculation. PMT Returns the payment amount for a loan. Use the PMT formula to take a date as a parameter and return a time period as a result. POWER Returns the result of a number raised to a given power. Use the POWER function. PPMT Returns the payment on the principal for a particular payment. See the Financial Functions. PRICE Returns the price per \$100 face value of a security that pays periodic interest. Use the PRICE function. PRODUCT Multiplies the numbers and returns the product. Use an intermediate line item with the summary as the product. PROPER Sets the first character in each word to uppercase and the rest to lowercase. There is no equivalent Anaplan function, but can be built using a calculation. PV Returns the present value of an investment. Use the PV function to calculate the present value of future cash flows.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.