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 update Anapedia content regularly to provide the most up-to-date instructions.