Comparisons of Microsoft Excel functions to those available in Anaplan.
Excel function | Excel description | Anaplan solution |
ODD | Rounds a number up to the nearest odd integer. | There's no equivalent Anaplan function, but this can be built using a ROUND calculation. |
OFFSET | Returns 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. |
OR | Returns TRUE if any of the conditions are true. | Use operators and constants with your data to create calculations and find the data you need. |