IBM Lotus Symphony


Applying Multiple Operations

Multiple Operations in Columns or Rows

The Data - Multiple Operations command provides a planning tool for "what if" questions.In your spreadsheet, you enter a formula to calculate a result from values that are stored in other cells. Then, you set up a cell range where you enter some fixed values, and the Multiple Operations command will calculate the results depending on the formula.

In the Formula field, enter the cell reference to the formula that applies to the data range. In the Column input cell/Row input cell field, enter the cell reference to the corresponding cell that is part of the formula.

Multiple Operations Across Rows and Columns

Lotus® Symphony™ allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the Formula field. The Row input cell and the Column input cell fields are used to enter the reference to the corresponding cells of the formula.


Product Feedback | Additional Documentation | Trademarks