Comparisons of Microsoft Excel functions to those available in Anaplan.
Excel comparison: O functions
| 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. |
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.