Using Formulae Instead of Values
|Help Home Previous Next|
By inserting formulae instead of values within the unprotected, cream assumption rows within assumption reports, it is possible to reduce the number of values to be entered every time the model is altered. For example:
The scope for using formulae is considerable. For example, they could be used to handle foreign currency transactions by inserting additional schedules for projected sales in local currencies and adding a further row for projected exchange rates to convert these values to the currency used throughout Exl-Plan.
When using formulae instead of values, avoid creation of circular calculations which may become evident if Exl-Plan apparently fails to update even after pressing the F9 function key etc.
We offer generous terms to users seeking to trade up from a "paid-for" copy of Basic to a more powerful version for the purpose of generating more detailed monthly and quarterly multi-year projections and to gain access to a range of powerful planning tools for "what-ifs" sensitivity analyses, profitability improvement etc. For details, visit this special page at <http://www.planware.org/exltradeup.htm>.
Online: Support Purchase