Formulas

Formulas allow you to do basic math (addition, subtraction, multiplication and division) on numbers that are in a table. These can be cells that contain only numbers or cells including both words and numbers.

To insert a formula, first open the topic you would like to add the formula to. If a table has not already been created, create one. Place your cursor where you would like to insert the formula. Next click the Formula button on the toolbar which launches the Formula window described below:

FormulaDialog

Formula Field – This where the formula expression is entered or modified. Delete an existing formula expression by blanking out this field.

Formula Options – Select one of these two options, depending on how you want the formula to behave. Choose the first option if the formula will be in a paragraph with other text or if you want to control how many decimal places the result of the formula should have. Select the second option if the formula is going into a table cell and you want 2 decimal places.

Decimal Places – If you chose option one above, use the up and down arrows to select the number of decimal places for the result of the formula.

Usage and Examples – Under the word “Usage” you will find a quick reference on using formulas and a few examples of what you can do with them.

There are two different types of formula expressions in WhisperReporter. Expressions that use “named paragraphs” (Advanced) and those that do not (Simple).