IBM Lotus Symphony
|
Using variables in equations, you can calculate a value that, as part of a formula, leads to the result you specify for the formula. You thus define the formula with several fixed values and one variable value and the result of the formula.
You can define a formula with several fixed values and one variable value and calculate the result of the formula. For example, to calculate annual interest, create a table with the values for the capital (C), number of years (n), and interest rate (i). The formula is: I = C * n* i / 100.
You can also enter the formula using the variable names as entered in the headings cells:
= 'Capital (C)' * 'Years (n)' * 'Interest rate (i)' / 100.
Each name must be spelled in the formula exactly as it is seen in the cell, and the name must be enclosed in single quotes.
![]() |
In this example, the investment capital of $150,000 and an interest rate of 7.5% is calculated to result in annual interest income of $11,250. The cells are formatted after calculation.