How to use the formula library
The function library contains reusable calculations for financial, geometric, and conversion tasks. Most library functions are formulas stored in the application; a few numerical functions are implemented natively.
Functions take one or more parameters inside parentheses. Use semicolons between parameters when entering a formula directly:
Each parameter may be a number, variable, or complete expression.
In the quick calculator, selecting a function starts parameter-collection mode. The grey message area tells you which parameter to enter. Press TAB to accept each parameter. After the final parameter, FormulaCalculator adds the closing parenthesis automatically.
Intermediate evaluation pauses while parameters are being collected. Evaluation resumes when the function is complete.
The lower help drawer describes the function and its parameters. Its text can be selected and copied.
When you press =, the print roll records the call and result. If function documentation is enabled, it also records the parameter descriptions and stored formulas.
You can also enter a function manually in Edit mode or in a calculation sheet. The name, number of parameters, and semicolon separators must be correct.
In a calculation sheet, point at a library function and choose Expand from Library from the context menu to replace the call with its underlying calculations. The actual arguments are substituted directly into the expanded formulas, and temporary variables are given short unique names. A comment containing the original call is inserted before the expansion.
RELATED TOPICS