All formulas begin with an equals
sign. The formulas can contain numbers, text, arithmetic operators,
logic operators, or functions.
|
Remember that the basic arithmetic operators (+, -, *, /) can
be used in formulas using the "Multiplication and Division before
Addition and Subtraction" rule. Instead of writing =SUM(A1:B1) you
can write =A1+B1. |
|
Parentheses can also be used. The result of the formula =(1+2)*3
produces a different result than =1+2*3. |
Here are a few examples of Lotus® Symphony™ Spreadsheets formulas:
Table 1. Examples of formulasFormula |
Result |
=A1+10 |
Displays the contents of cell A1 plus 10. |
=A1*16% |
Displays 16% of the contents of A1. |
=A1 * A2 |
Displays the result of the multiplication of
A1 and A2. |
=ROUND(A1;1) |
Displays the contents of cell A1 rounded to
one decimal place. |
=EFFECTIVE(5%;12) |
Calculates the effective interest for 5% annual
nominal interest with 12 payments a year. |
=B8-SUM(B10:B14) |
Calculates B8 minus the sum of the cells B10
to B14. |
=SUM(B8;SUM(B10:B14)) |
Calculates the sum of cells B10 to B14 and
adds the value to B8. |
=SUM(B1:B65536) |
Sums all numbers in column B. |
It is also possible to nest functions in formulas,
as shown in the example. You can also nest functions within functions.
The Function Wizard assists you with nested functions.
Note: Lotus Symphony Spreadsheets can
assist users by giving formula hot hints.