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
LARGEReturns the nth largest value from a set of values.There is no equivalent Anaplan function, but can be built using a calculation.
LEFTExtract a substring from a string, starting from the leftmost character.Use the LEFT function.
LENReturns the length of the specified string.Use the LENGTH function to return the number of characters in a text string.
LINESTUses the least squares method to calculate the statistics for a straight line and returns an array describing that line.There is no equivalent Anaplan function, but can be built using a calculation.
LNReturns the natural logarithm of a number.Use the LN formula to return the natural logarithm of a number, based on the constant e.
LOGReturns the logarithm of a number to a specified base.Use the LOG formula.
LOG10Returns the base-10 logarithm of a number.Use the LOG formula to return the logarithm of a number to the specified base.
LOOKUPReturns a value from a range (one row or one column) or from an array.

Use the LOOKUP function to look up an amount from a source module using one or more mappings. Each mapping matches a:

  • List-formatted line item
  • Time period-formatted item
  • Property from the source with a dimension of the target line item.
LOWERConverts all letters in the specified string to lowercase.Use the LOWER formula.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.