| |
|
| |
div id"finanztext" a name"finanztext" h2 h2 This category contains the mathematical finance functions of span translate'0'Lotusspan® span translate'0'Symphonyspan™ Spreadsheets. div div id"amordegrc" a name"amordegrc" h2 h2 div div id"bmid3152578" a ... |
| |
|
| |
You can add the values in the cells of a table to display the sum in a separate cell of the same table or display the result in a different table. |
| |
|
| |
Automatically recalculates all formulas in the document. All cells are recalculated after a sheet cell has been modified. Any charts in the sheet will also be refreshed. div id"howtoget" a name"howtoget" h2 h2 div To access this command... Choose Tools Cell Contents Instant ... |
| |
|
| |
div id"oddfprice" a name"oddfprice" h2 h2 div div id"bmid3146107" a name"bmid3146107" h2 h2 div div id"HIDAAIFUNCODDFPRICE" a name"HIDAAIFUNCODDFPRICE" h2 h2 div h2 ODDFPRICE h2
Calculates the price per 100 currency units par value of a ... |
| |
|
| |
Choose Table Create Table, and insert a table with one column and more than one row into a text document. Type a number in each cell of the column, but leave the last cell in the column empty. Place the cursor in the last cell of the column, and then click the Sum icon on the toolbar. The ... |
| |
|
| |
You can set the field display name, calculate subtotals, and sort the values of page, column, or row areas in a DataPilot table by setting the field option. The current field name is displayed in the title of the window. |
| |
|
| |
You can insert a calculation result directly into a document. |
| |
|
| |
div id"trendlinestext" a name"trendlinestext" Regression curves, also known as trend lines, can be added to all 2D chart types except for Pie and Stock charts. div To access this command... Select Create Trend Lines (Charts) h2 Mean Value Line h2
Mean Value Lines are special ... |
| |
|
| |
div id"howtoget" a name"howtoget" h2 h2 div To access this command... Create Function Category Financial Financial Functions Part One ls301Back to Financial Functions Part One Financial Functions Part Three ls301Forward to Financial Functions Part Three div id"ppmt" ... |
| |
|
| |
You can perform calculations that span across more than one table in a text document. Open a text document, insert two tables, and type numbers in a few cells in both tables. Place your cursor in an empty cell in one of the tables. Press F2. In the Formula Bar, enter the function that you want to ... |
| |
|
| |
a name"howtoget" h2 h2 To access this command... Create Function Category Financial Financial Functions Part One: ls3Back to Financial Functions Part One Financial Functions Part Three: ls3Forward to Financial Functions Part Three a name"ppmt" h2 h2 a ... |
| |
|
| |
You can insert a calculation result directly into a document. |
| |
|
| |
Choose Table Create Table, and insert a table with one column and more than one row into a text document. Type a number in each cell of the column, but leave the last cell in the column empty. Place the cursor in the last cell of the column, and then click the Sum icon on the toolbar. The ... |
| |
|
| |
Automatically recalculates all formulas in the document. All cells are recalculated after a sheet cell has been modified. Any charts in the sheet will also be refreshed. a name"howtoget" h2 h2 To access this command... Choose Tools Cell Contents Instant Calculate |
| |
|
| |
You can perform calculations that span across more than one table in a text document. Open a text document, insert two tables, and type numbers in a few cells in both tables. Place your cursor in an empty cell in one of the tables. Press F2. In the Formula Bar, enter the function that you want to ... |
| |
|
| |
a name"finanztext" h2 h2 This category contains the mathematical finance functions of Lotus® Symphony™ Spreadsheets. a name"amordegrc" h2 h2 a name"bmid3152578" h2 h2 a name"HIDAAIFUNCAMORDEGRC" h2 h2 h2 AMORDEGRC h2
Calculates the amount of ... |
| |
|
| |
a name"oddfprice" h2 h2 a name"bmid3146107" h2 h2 a name"HIDAAIFUNCODDFPRICE" h2 h2 h2 ODDFPRICE h2
Calculates the price per 100 currency units par value of a security, if the first interest date falls irregularly. h2 Syntax h2
ODDFPRICE(Settlement; ... |
| |
|
| |
You can set the field display name, calculate subtotals, and sort the values of page, column, or row areas in a DataPilot table by setting the field option. The current field name is displayed in the title of the window. |
| |
|
| |
a name"trendlinestext" Regression curves, also known as trend lines, can be added to all 2D chart types except for Pie and Stock charts. To access this command... Select Create Trend Lines (Charts) h2 Mean Value Line h2
Mean Value Lines are special trend lines that show the mean value. ... |
| |
|
| |
You can add the values in the cells of a table to display the sum in a separate cell of the same table or display the result in a different table. |