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