<!DOCTYPE html>
<html lang="en-US">
<head>
<base href="../../../../">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Applying Multiple Operations</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="fuzzysort.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="en-US/langnames.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body itemscope="true" itemtype="http://schema.org/TechArticle">
<div class="header-extrawurst">
<header><div class="logo-container"><a class="logo" href="en-US/text/shared/05/new_help.html"><div class="symbol"></div>
<p>LibreOffice 6.4 Help</p></a></div></header><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" onclick="setupModules('', 'en-US');">Module</button><nav id="modules-nav"></nav>
</div>
</div>
<aside class="rightside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1">Contents</label><div id="Contents" class="contents-treeview"></div></aside><aside class="leftside"><div id="Index">
<div class="index-label">Index 🔎︎ </div>
<div id="Bookmarks">
<input id="search-bar" type="text" class="search" placeholder="Search in chosen module"><nav class="index"></nav>
</div>
</div></aside><div id="DisplayArea" itemprop="articleBody">
<a name="bm_id3147559"></a><meta itemprop="keywords" content="multiple operations">
<meta itemprop="keywords" content="what if operations,two variables">
<meta itemprop="keywords" content="tables, multiple operations in">
<meta itemprop="keywords" content="data tables, multiple operations in">
<meta itemprop="keywords" content="cross-classified tables">
<h1 itemprop="articleSection" id="hd_id3147559">
<a name="multioperation"></a>Applying Multiple Operations
</h1>
<h2 itemprop="articleSection" id="hd_id3145171">Multiple Operations in Columns or Rows</h2>
<p id="par_id4123966" class="paragraph">The <span class="menuitem">Data - Multiple Operations</span> 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.</p>
<p id="par_id3156424" class="paragraph">In the <span class="emph">Formulas</span> field, enter the cell reference to the formula that applies to the data range. In the <span class="emph">Column input cell/Row input cell</span> field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples:</p>
<h3 id="hd_id3159153">Examples</h3>
<p id="par_id3153189" class="paragraph">You produce toys which you sell for $10 each. Each toy costs $2 to make, in addition to which you have fixed costs of $10,000 per year. How much profit will you make in a year if you sell a particular number of toys?</p>
<p id="par_id6478774" class="paragraph">
<img src="media/helpimg/what-if.png" class="genericimage" alt="what-if sheet area" title="what-if sheet area" style="width:21px;height:21px"></p>
<h3 id="hd_id3145239">Calculating With One Formula and One Variable</h3>
<ol>
<li>
<p id="par_id3146888" class="listitem">To calculate the profit, first enter any number as the quantity (items sold) - in this example 2000. The profit is found from the formula Profit=Quantity * (Selling price - Direct costs) - Fixed costs. Enter this formula in B5.</p>
</li>
<li>
<p id="par_id3157875" class="listitem">In column D enter given annual sales, one below the other; for example, 500 to 5000, in steps of 500.</p>
</li>
<li>
<p id="par_id3159115" class="listitem">Select the range D2:E11, and thus the values in column D and the empty cells alongside in column E.</p>
</li>
<li>
<p id="par_id3149723" class="listitem">Choose <span class="emph">Data - Multiple operations</span>.</p>
</li>
<li>
<p id="par_id3149149" class="listitem">With the cursor in the <span class="emph">Formulas </span>field, click cell B5.</p>
</li>
<li>
<p id="par_id3149355" class="listitem">Set the cursor in the <span class="emph">Column input cell</span> field and click cell B4. This means that B4, the quantity, is the variable in the formula, which is replaced by the selected column values.</p>
</li>
<li>
<p id="par_id3149009" class="listitem">Close the dialog with <span class="emph">OK</span>. You see the profits for the different quantities in column E.</p>
</li>
</ol>
<h3 id="hd_id3148725">Calculating with Several Formulas Simultaneously</h3>
<ol>
<li>
<p id="par_id3146880" class="listitem">Delete column E.</p>
</li>
<li>
<p id="par_id3154675" class="listitem">Enter the following formula in C5: = B5 / B4. You are now calculating the annual profit per item sold.</p>
</li>
<li>
<p id="par_id3148885" class="listitem">Select the range D2:F11, thus three columns.</p>
</li>
<li>
<p id="par_id3147474" class="listitem">Choose <span class="emph">Data - Multiple Operations</span>.</p>
</li>
<li>
<p id="par_id3154846" class="listitem">With the cursor in the <span class="emph">Formulas</span> field, select cells B5 thru C5.</p>
</li>
<li>
<p id="par_id3153931" class="listitem">Set the cursor in the <span class="emph">Column input cell</span> field and click cell B4.</p>
</li>
<li>
<p id="par_id3150862" class="listitem">Close the dialog with <span class="emph">OK</span>. You will now see the profits in column E and the annual profit per item in column F.</p>
</li>
</ol>
<h2 itemprop="articleSection" id="hd_id3146139">Multiple Operations Across Rows and Columns</h2>
<p id="par_id3148584" class="paragraph">
<span class="productname">LibreOffice</span> 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 <span class="emph">Formulas</span> field. The <span class="emph">Row input cell</span> and the <span class="emph">Column input cell</span> fields are used to enter the reference to the corresponding cells of the formula.</p>
<h3 id="hd_id3149949">Calculating with Two Variables</h3>
<p id="par_id3154808" class="paragraph">Consider columns A and B of the sample table above. 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.</p>
<p id="par_id3149731" class="paragraph">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.</p>
<ol>
<li>
<p id="par_id3152810" class="listitem">Select the range D1:H11.</p>
</li>
<li>
<p id="par_id3153620" class="listitem">Choose <span class="emph">Data - Multiple Operations</span>.</p>
</li>
<li>
<p id="par_id3149981" class="listitem">With the cursor in the <span class="emph">Formulas</span> field, click cell B5.</p>
</li>
<li>
<p id="par_id3156113" class="listitem">Set the cursor in the <span class="emph">Row input cell</span> 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).</p>
</li>
<li>
<p id="par_id3154049" class="listitem">Set the cursor in the <span class="emph">Column input cell</span> field and click in B4. This means that B4, the quantity, is the vertically entered variable.</p>
</li>
<li>
<p id="par_id3149141" class="listitem">Close the dialog with OK. You see the profits for the different selling prices in the range E2:H11.</p>
</li>
</ol>
<a name="relatedtopics"></a><div class="relatedtopics">
<p class="related" itemprop="mentions"><a name="related"></a><span class="emph">Related Topics</span>
</p>
<div class="relatedbody" itemprop="mentions">
<p id="par_id3155104" class="paragraph"><a target="_top" href="en-US/text/scalc/01/12060000.html">Multiple operations</a></p>
<div class="embedded"><p class="embedded"><a name="scenario"></a><a target="_top" href="en-US/text/scalc/guide/scenario.html">Using Scenarios</a>
</p></div>
</div>
</div>
</div>
<div class="search-frame"></div>
<div class="donation-frame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p>This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/scalc/guide/multioperation.xhp" target="_blank">/text/scalc/guide/multioperation.xhp</a></p>
<p>Title is: Applying Multiple Operations</p>
<p id="bm_module"></p>
<p id="bm_system"></p>
<p id="bm_HID"></p>
</div></footer>
</body>
</html>
| Name | Type | Size | Permission | Actions |
|---|---|---|---|---|
| address_auto.html | File | 6.34 KB | 0644 |
|
| auto_off.html | File | 6.82 KB | 0644 |
|
| autofilter.html | File | 6.93 KB | 0644 |
|
| autoformat.html | File | 5.89 KB | 0644 |
|
| background.html | File | 5.48 KB | 0644 |
|
| borders.html | File | 13.91 KB | 0644 |
|
| calc_date.html | File | 5.68 KB | 0644 |
|
| calc_series.html | File | 7.9 KB | 0644 |
|
| calc_timevalues.html | File | 3.88 KB | 0644 |
|
| calculate.html | File | 4.83 KB | 0644 |
|
| cell_enter.html | File | 5.78 KB | 0644 |
|
| cell_protect.html | File | 8.4 KB | 0644 |
|
| cell_unprotect.html | File | 4.05 KB | 0644 |
|
| cellcopy.html | File | 6 KB | 0644 |
|
| cellreference_dragdrop.html | File | 5.55 KB | 0644 |
|
| cellreferences.html | File | 7.89 KB | 0644 |
|
| cellreferences_url.html | File | 5.8 KB | 0644 |
|
| cellstyle_by_formula.html | File | 5.69 KB | 0644 |
|
| cellstyle_conditional.html | File | 11.13 KB | 0644 |
|
| cellstyle_minusvalue.html | File | 4.84 KB | 0644 |
|
| consolidate.html | File | 7.86 KB | 0644 |
|
| csv_files.html | File | 8.52 KB | 0644 |
|
| csv_formula.html | File | 7.83 KB | 0644 |
|
| currency_format.html | File | 6.4 KB | 0644 |
|
| database_define.html | File | 5.14 KB | 0644 |
|
| database_filter.html | File | 6.94 KB | 0644 |
|
| database_sort.html | File | 4.46 KB | 0644 |
|
| datapilot.html | File | 4.93 KB | 0644 |
|
| datapilot_createtable.html | File | 7.93 KB | 0644 |
|
| datapilot_deletetable.html | File | 5 KB | 0644 |
|
| datapilot_edittable.html | File | 6.43 KB | 0644 |
|
| datapilot_filtertable.html | File | 7.52 KB | 0644 |
|
| datapilot_grouping.html | File | 5.42 KB | 0644 |
|
| datapilot_tipps.html | File | 5.58 KB | 0644 |
|
| datapilot_updatetable.html | File | 4.96 KB | 0644 |
|
| dbase_files.html | File | 7.72 KB | 0644 |
|
| design.html | File | 6 KB | 0644 |
|
| edit_multitables.html | File | 4.92 KB | 0644 |
|
| filters.html | File | 5.96 KB | 0644 |
|
| finding.html | File | 7.59 KB | 0644 |
|
| format_table.html | File | 6.51 KB | 0644 |
|
| format_value.html | File | 6.08 KB | 0644 |
|
| format_value_userdef.html | File | 7.56 KB | 0644 |
|
| formula_copy.html | File | 5.33 KB | 0644 |
|
| formula_enter.html | File | 6.79 KB | 0644 |
|
| formula_value.html | File | 4.36 KB | 0644 |
|
| formulas.html | File | 6.45 KB | 0644 |
|
| fraction_enter.html | File | 4.39 KB | 0644 |
|
| goalseek.html | File | 6.14 KB | 0644 |
|
| html_doc.html | File | 5.91 KB | 0644 |
|
| integer_leading_zero.html | File | 6.08 KB | 0644 |
|
| keyboard.html | File | 7.85 KB | 0644 |
|
| line_fix.html | File | 5.72 KB | 0644 |
|
| main.html | File | 22.58 KB | 0644 |
|
| mark_cells.html | File | 6.82 KB | 0644 |
|
| matrixformula.html | File | 4.72 KB | 0644 |
|
| move_dragdrop.html | File | 9.4 KB | 0644 |
|
| multi_tables.html | File | 4.51 KB | 0644 |
|
| multioperation.html | File | 9.26 KB | 0644 |
|
| multitables.html | File | 5.97 KB | 0644 |
|
| note_insert.html | File | 5.34 KB | 0644 |
|
| numbers_text.html | File | 9.54 KB | 0644 |
|
| pivotchart.html | File | 4.91 KB | 0644 |
|
| pivotchart_create.html | File | 5.76 KB | 0644 |
|
| pivotchart_delete.html | File | 4.77 KB | 0644 |
|
| pivotchart_edit.html | File | 7.79 KB | 0644 |
|
| pivotchart_filter.html | File | 5.41 KB | 0644 |
|
| pivotchart_update.html | File | 4.56 KB | 0644 |
|
| print_details.html | File | 5.24 KB | 0644 |
|
| print_exact.html | File | 4.84 KB | 0644 |
|
| print_landscape.html | File | 6.95 KB | 0644 |
|
| print_title_row.html | File | 6.4 KB | 0644 |
|
| printranges.html | File | 7.71 KB | 0644 |
|
| relativ_absolut_ref.html | File | 7.76 KB | 0644 |
|
| rename_table.html | File | 7.49 KB | 0644 |
|
| rounding_numbers.html | File | 5.81 KB | 0644 |
|
| row_height.html | File | 5.25 KB | 0644 |
|
| scenario.html | File | 6.81 KB | 0644 |
|
| sorted_list.html | File | 5.1 KB | 0644 |
|
| specialfilter.html | File | 11.25 KB | 0644 |
|
| super_subscript.html | File | 4.19 KB | 0644 |
|
| table_cellmerge.html | File | 4.88 KB | 0644 |
|
| table_rotate.html | File | 4.28 KB | 0644 |
|
| table_view.html | File | 4.65 KB | 0644 |
|
| text_numbers.html | File | 5.23 KB | 0644 |
|
| text_rotate.html | File | 4.05 KB | 0644 |
|
| text_wrap.html | File | 4.12 KB | 0644 |
|
| userdefined_function.html | File | 8.33 KB | 0644 |
|
| validity.html | File | 7.79 KB | 0644 |
|
| value_with_name.html | File | 7.99 KB | 0644 |
|
| webquery.html | File | 7.11 KB | 0644 |
|
| year2000.html | File | 4.12 KB | 0644 |
|