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 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.