1. Calculation functions
  2. Functions
  3. Excel comparison
  4. Excel comparison: F functions

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
FACTReturns the factorial of a number.There is no equivalent Anaplan function, but can be built using a calculation.
FALSEReturns a logical value of FALSE.Use the boolean argument in a IF THEN ELSE function.
FINDReturns the location of a substring in a string (case-sensitive).Use the FIND function to look for a text string in a text-formatted item, starting at a specified character number. The result is a number that denotes the character position.
FIXEDReturns a text representation of a number rounded to a specified number of decimal places.Use the TEXT function to convert a numeric value in a text field to a number format.
FLOORReturns a number rounded down based on a multiple of significance.There is no equivalent Anaplan function, but can be built using a calculation.
FORECASTReturns a prediction of a future value based on existing values provided.Use the FV function.
FREQUENCYReturns how often values occur within a set of data. It returns a vertical array of numbers.There is no equivalent Anaplan function, but can be built using a calculation.
FVReturns the future value of an investment.Use the FV function.

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.