Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 21 Jan 2014 21:43:07 +0100How do I multiply 1 number to a range of cells?https://ask.libreoffice.org/en/question/28595/how-do-i-multiply-1-number-to-a-range-of-cells/I have been trying to figure out how can I write a formula that will multiply one number to each cell within a table on a spreadsheet.
Each number in the cells needs to multiplied by the same number. I want to be able to change that one number as price increases happen.
I can't seem to get it any help would be great. Mon, 20 Jan 2014 22:40:01 +0100https://ask.libreoffice.org/en/question/28595/how-do-i-multiply-1-number-to-a-range-of-cells/Answer by oweng for <p>I have been trying to figure out how can I write a formula that will multiply one number to each cell within a table on a spreadsheet.
Each number in the cells needs to multiplied by the same number. I want to be able to change that one number as price increases happen.
I can't seem to get it any help would be great. </p>
https://ask.libreoffice.org/en/question/28595/how-do-i-multiply-1-number-to-a-range-of-cells/?answer=28596#post-id-28596Given an array (table) of numbers (e.g., A1:C3) and a single other multiplier (e.g., D1), you are going to need a second array for the formulas (answers) to go (e.g., E1:G3). Use relative addressing to refer to the first cell in the first array (e.g., `A1`) and [absolute addressing](https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative#Absolute_Addressing) to refer to the multiplier (e.g., `$D$1`). For example,
1. In E1 enter `=A1*$D$1`.
2. Click and drag this cell to G1.
3. With E1:G1 still highlighted, click and drag this cell range to G3.
EDIT: Also refer [this](http://ask.libreoffice.org/en/question/28657/array-function-help/?answer=28669#post-id-28669) answer.Mon, 20 Jan 2014 23:05:17 +0100https://ask.libreoffice.org/en/question/28595/how-do-i-multiply-1-number-to-a-range-of-cells/?answer=28596#post-id-28596Comment by bencomp for <p>Given an array (table) of numbers (e.g., A1:C3) and a single other multiplier (e.g., D1), you are going to need a second array for the formulas (answers) to go (e.g., E1:G3). Use relative addressing to refer to the first cell in the first array (e.g., <code>A1</code>) and <a href="https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative#Absolute_Addressing">absolute addressing</a> to refer to the multiplier (e.g., <code>$D$1</code>). For example, </p>
<ol>
<li>In E1 enter <code>=A1*$D$1</code>.</li>
<li>Click and drag this cell to G1.</li>
<li>With E1:G1 still highlighted, click and drag this cell range to G3.</li>
</ol>
<p>EDIT: Also refer <a href="http://ask.libreoffice.org/en/question/28657/array-function-help/?answer=28669#post-id-28669">this</a> answer.</p>
https://ask.libreoffice.org/en/question/28595/how-do-i-multiply-1-number-to-a-range-of-cells/?comment=28663#post-id-28663You could also select the D1 cell, give it a name and use the name in formulas.Tue, 21 Jan 2014 21:43:07 +0100https://ask.libreoffice.org/en/question/28595/how-do-i-multiply-1-number-to-a-range-of-cells/?comment=28663#post-id-28663