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