Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

Multiple operations across rows and columns

You can carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell must 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.

Calculating with two variables

You now want to vary not just the quantity produced annually, but also the selling price, and you are interested in the profit in each case.

Expand the table shown above. D2 thru D11 contain the numbers 500, 1000 and so on, up to 5000. In E1 through H1 enter the numbers 8, 10, 15 and 20.

  1. Select the range D1:H11.
  2. Choose Data > Multiple Operations.
  3. With the cursor in the Formulas field of the Multiple operations dialog, click cell B5 (profit).
  4. Set the cursor in the Row input cell field and click cell B1. This means that B1, the selling price, is the horizontally entered variable (with the values 8, 10, 15 and 20).
  5. Set the cursor in the Column input cell field and click cell B4. This means that B4, the quantity, is the vertically entered variable.
  6. Sheet and dialog showing input
  7. Click OK. The profits for the different selling prices are now shown in the range E2:H11.
  8. Results of multiple operations calculations

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire