Comparisons of Microsoft Excel functions to those available in Anaplan.

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


Excel functionExcel descriptionAnaplan solution
NConverts a value to a number.Use the VALUE function.
NAReturns the #N/A error value.There's no equivalent Anaplan function.
NETWORKDAYSReturns the number of work days between two dates, excluding weekends and holidays.There's no equivalent Anaplan function, but can be built using a calculation.
NETWORKDAYS.INTLReturns the number of work days between two dates, excluding weekends and holidays.This is supported by the Anaplan settings.
NOTReturns the reversed logical value.Use operators and constants to create calculations and find the data you need.
NOWReturns the current system date and time.There's no equivalent Anaplan function. However, you can create a module called Today, with one date formatted line item that is selected when required.
NPERReturns the number of periods for an investment.Use the NPER function.
NPVReturns the net present value of an investment.Use the NPV function.


We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.