Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| N | Converts a value to a number. | Use the VALUE function. |
| NA | Returns the #N/A error value. | There's no equivalent Anaplan function. |
| NETWORKDAYS | Returns 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.INTL | Returns the number of work days between two dates, excluding weekends and holidays. | This is supported by the Anaplan settings. |
| NOT | Returns the reversed logical value. | Use operators and constants to create calculations and find the data you need. |
| NOW | Returns 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. |
| NPER | Returns the number of periods for an investment. | Use the NPER function. |
| NPV | Returns the net present value of an investment. | Use the NPV function. |
