MENU
    Dynamic Planning SpotlightXL User Guide Function Support
    • 1 Minute to read
    • Dark
    • PDF

    Dynamic Planning SpotlightXL User Guide Function Support

    • Dark
    • PDF

    Article summary

    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?