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
PERCENTILEReturns the nth percentile from a set of values.There is no equivalent Anaplan function, but can be built using a calculation.
PERCENTRANKReturns 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

PERMUTReturns 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
PIReturns the mathematical constant called pi.There is no equivalent Anaplan function, but can be built using a calculation.
PMTReturns 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.
POWERReturns the result of a number raised to a given power.Use the POWER function.
PPMTReturns the payment on the principal for a particular payment.See the Financial Functions.
PRICEReturns the price per $100 face value of a security that pays periodic interest.Use the PRICE function.
PRODUCTMultiplies the numbers and returns the product.Use an intermediate line item with the summary as the product.
PROPERSets 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.
PVReturns the present value of an investment.Use the PV function to calculate the present value of future cash flows.