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

Comparisons of Microsoft Excel functions to those available in Anaplan.

Use the links below to navigate to pages containing other Microsoft Excel functions.


Excel functionExcel descriptionAnaplan solution
ODDRounds a number up to the nearest odd integer.There's no equivalent Anaplan function, but this can be built using a ROUND calculation.
OFFSETReturns a reference to a range that is offset a number of rows and columns.There's no equivalent Anaplan function, but can be built using a calculation.
ORReturns TRUE if any of the conditions are true.Use operators and constants with your data to create calculations and find the data you need.


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.