Comparisons of Microsoft Excel functions to those available in Anaplan.
Excel function | Excel description | Anaplan solution |
FACT | Returns the factorial of a number. | There is no equivalent Anaplan function, but can be built using a calculation. |
FALSE | Returns a logical value of FALSE. | Use the boolean argument in a IF THEN ELSE function. |
FIND | Returns 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. |
FIXED | Returns 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. |
FLOOR | Returns a number rounded down based on a multiple of significance. | There is no equivalent Anaplan function, but can be built using a calculation. |
FORECAST | Returns a prediction of a future value based on existing values provided. | There is no equivalent Anaplan function, but can be built using a calculation. |
FREQUENCY | Returns 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. |
FV | Returns the future value of an investment. | Use the FV function. |