Comparisons of Microsoft Excel functions to those available in Anaplan.
| Excel function | Excel description | Anaplan solution |
| VALUE | Converts a text value that represents a number to a number. | Use the VALUE formula to convert a numeric value in a text field to a number format. |
| VAR | Returns the variance of a population based on a sample of numbers. | Use the SELECT and COLLECT formulas with line items to calculate the variance. |
| VARA | Returns the variance of a population based on a sample of numbers, text, and logical values. | Use the SELECT and COLLECT formulas with line items to calculate the variance. |
| VARP | Returns the variance of a population based on an entire population of numbers. | Use the SELECT and COLLECT formulas with line items to calculate the variance. |
| VARPA | Returns the variance of a population based on an entire population of numbers, text, and logical values. | Use the SELECT and COLLECT formulas with line items to calculate the variance. |
| VDB | Returns the depreciation of an asset based on a variable declining balance depreciation method. | See the Financial functions. |
| VLOOKUP | Performs a vertical lookup by searching for a value in the first column in a table, and returning it to the same row in the index_number position. | Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a:
|
