Home → Techniques and Tips → TopRank → INDIRECT and OFFSET with TopRank
Applies to: TopRank 6.x/7.x
When I let TopRank discover inputs, can it interpret Excel's INDIRECT( ) and OFFSET( ) functions?
Yes, TopRank interprets those functions when you add the output or begin analysis, depending on the checkboxes in Analysis Settings » Find Inputs, and can go through those functions to find inputs.
The functions are evaluated once only. If their values change later — for instance, if an INDIRECT( ) points to different cells during the analysis — TopRank will not update its list of inputs dynamically.
Last edited: 2015-09-11