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:
