HomeTechniques and TipsTopRankINDIRECT and OFFSET with TopRank

18.1. 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

This page was: Helpful | Not Helpful