• Business Functions
• Summary
• Function Selector
• Function Finder
• Trace
• Help
• Function Examples
• Tutorials
• Monte Carlo
• GoalSeek
• Utilities
• Callable from VBA
• Array Functions
• CashFlow Administrator
• Select Function
• Number Formats
• Functions Overview

Trace

Screenshot

• Detailed information on each functions calculations.
• Trace is invoked by, instead of recalculating the spreadsheet or using F2 to edit/calc the cell, simply selecting Trace from the BF menu. A dialog box then pops up with information on the calculations the function has performed.
• Provides explanation of any errors, especially #NUM! errors.
• If one or more input variables are incorrectly specified (ie wrong), Trace tells you which variable was at fault, and waht was wrong with it.
• If a function fails during its calculations (quite rare), Trace provides an audit trail to the point where the failure occurred.
• Trace generates quite a lot of detail - sometimes too much and we are looking at ways of organising its output - but where it excels is in the screening of the inputs and the message it gives whene an error is encountered or occurs.