| |
|
| |
All formulas begin with an equals sign. The formulas can contain numbers, text, arithmetic operators, logic operators, or functions. {{BottomLeftLighting16x16.pngTip Icon} } Remember that the basic arithmetic operators (+, , , ) can be used in formulas using the "Multiplication and Division ... |
| |
|
| |
Switches the Instant Input function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings. Adjusting Instant Correction Formatting ls301Deactivating Automatic Changes div ... |
| |
|
| |
Displays information about the current document. By default, the SUM of the contents of the selected cells is displayed. To change the default formula that is displayed, rightclick the field, and then choose the formula that you want. The available formulas are: Average, count of values (COUNTA), ... |
| |
|
| |
If you want to display the formulas in the cells, for example in the form SUM(A1:B5), proceed as follows: Choose File Preferences Symphony Lotus Symphony Spreadsheets View. In the Display area mark the Formulas box. Click OK. If you want to view the calculation results instead of the ... |
| |
|
| |
div id"copytext" a name"copytext" h2 h2 There are various ways to copy a formula. One suggested method is: Select the cell containing the formula. Choose Edit Copy, or press Ctrl+C to copy it. Select the cell into which you want the formula to be copied. Choose Edit Paste, or press ... |
| |
|
| |
You can use the following operators in span translate'0'Lotusspan® span translate'0'Symphonyspan™ Spreadsheets: h2 Arithmetical Operators h2
These operators return numerical results. Table 1. Arithmetical operators
Operator Name Example
+ (Plus) Addition 1+1
(Minus) ... |
| |
|
| |
a name"copytext" h2 h2 There are various ways to copy a formula. One suggested method is: Select the cell containing the formula. Choose Edit Copy, or press Ctrl+C to copy it. Select the cell into which you want the formula to be copied. Choose Edit Paste, or press Ctrl+V. The formula ... |
| |
|
| |
If you want to display the formulas in the cells, for example in the form SUM(A1:B5), proceed as follows: Choose File Preferences Symphony Lotus Symphony Spreadsheets View. In the Display area mark the Formulas box. Click OK. If you want to view the calculation results instead of the ... |
| |
|
| |
Displays information about the current document. By default, the SUM of the contents of the selected cells is displayed. To change the default formula that is displayed, rightclick the field, and then choose the formula that you want. The available formulas are: Average, count of values (COUNTA), ... |
| |
|
| |
All formulas begin with an equals sign. The formulas can contain numbers, text, arithmetic operators, logic operators, or functions. {{BottomLeftLighting16x16.pngTip Icon} } Remember that the basic arithmetic operators (+, , , ) can be used in formulas using the "Multiplication and Division ... |
| |
|
| |
You can use the following operators in Lotus® Symphony™ Spreadsheets: h2 Arithmetical Operators h2
These operators return numerical results. Table 1. Arithmetical operators
Operator Name Example
+ (Plus) Addition 1+1
(Minus) Subtraction 21
(Minus) Negation 5
... |