Dynamic Planning SpotlightXL User Guide Function Support

Article summary

Did you find this summary helpful?

Thank you for your feedback

The following functions are supported in SpotlightXL:

Arithmetic Operators: + - / *
Logical Operators used with IF function: = <> < <= > <=
Functions: IF/THEN, AND, OR, ROUND, FLOOR, CEILING, LN, ISBLANK, ABS, SQRT, POWER, MOD

Tip

All function and operator syntax is similar to Excel syntax.

For detailed information about the model formula, click here.

Was this article helpful?