Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 12 Oct 2017 20:14:25 +0200How to get multiple results of a cell?https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/ What I'd like to achive is the following: I have a sheet that calculates the price of a certain item. It contains a lot of options, like what materials are used, what tools are used, etc in order to create the stuff, and there is a cell, which contains the amount, so I can calculate how much it will cost the client, if they order for example 1, 5 or any amount. It works fine, but I'd also like to have a little table, in which I could automaticly see the prices, if the amount is 1, 5, 20 and 50 (these are the usual request), without having to manually change the amount to the aforementioned numbers. So to sum things up, I'd like a function or something, that gets the result of cell 'B' (the final price), if cell 'A' (the amount) is 1, 5, 20 and 50.Thu, 12 Oct 2017 14:26:08 +0200https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/Answer by Jim K for <p>What I'd like to achive is the following: I have a sheet that calculates the price of a certain item. It contains a lot of options, like what materials are used, what tools are used, etc in order to create the stuff, and there is a cell, which contains the amount, so I can calculate how much it will cost the client, if they order for example 1, 5 or any amount. It works fine, but I'd also like to have a little table, in which I could automaticly see the prices, if the amount is 1, 5, 20 and 50 (these are the usual request), without having to manually change the amount to the aforementioned numbers. So to sum things up, I'd like a function or something, that gets the result of cell 'B' (the final price), if cell 'A' (the amount) is 1, 5, 20 and 50.</p>
https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?answer=134454#post-id-134454The normal way is to enter the amounts in 4 different cells, for example, A1 through A4. Then calculate the final result in B1 based on A1.
Use [absolute referencing](https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative) in B1 for all cells except A1. For example, if tools are always listed in cell G8, then reference it as $G$8.
Then drag to fill the formula down from B1 to B4.Thu, 12 Oct 2017 17:35:45 +0200https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?answer=134454#post-id-134454Comment by szubzerus for <p>The normal way is to enter the amounts in 4 different cells, for example, A1 through A4. Then calculate the final result in B1 based on A1.</p>
<p>Use <a href="https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative">absolute referencing</a> in B1 for all cells except A1. For example, if tools are always listed in cell G8, then reference it as $G$8.</p>
<p>Then drag to fill the formula down from B1 to B4.</p>
https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?comment=134471#post-id-134471Hi Jim and thanks for the answer! Though it did not really solve my problem, so let me specify it a bit more. The price calculator sheet looks something like this:
Amount: 5
… cost of used material: 120
… preparation: 300
… work: 240
Final price: 660
So the final price is the sum of the three above. What I'm looking for is like a function, that puts a certain number in the amount cell, and returns with the final price cell, without actually changing them.Thu, 12 Oct 2017 19:54:44 +0200https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?comment=134471#post-id-134471Answer by Mike Kaganski for <p>What I'd like to achive is the following: I have a sheet that calculates the price of a certain item. It contains a lot of options, like what materials are used, what tools are used, etc in order to create the stuff, and there is a cell, which contains the amount, so I can calculate how much it will cost the client, if they order for example 1, 5 or any amount. It works fine, but I'd also like to have a little table, in which I could automaticly see the prices, if the amount is 1, 5, 20 and 50 (these are the usual request), without having to manually change the amount to the aforementioned numbers. So to sum things up, I'd like a function or something, that gets the result of cell 'B' (the final price), if cell 'A' (the amount) is 1, 5, 20 and 50.</p>
https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?answer=134472#post-id-134472Use [Scenarios](https://help.libreoffice.org/Calc/Using_Scenarios)
or [Multiple Operations](https://help.libreoffice.org/Calc/Applying_Multiple_Operations).Thu, 12 Oct 2017 19:57:46 +0200https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?answer=134472#post-id-134472Comment by szubzerus for <p>Use <a href="https://help.libreoffice.org/Calc/Using_Scenarios">Scenarios</a></p>
<p>or <a href="https://help.libreoffice.org/Calc/Applying_Multiple_Operations">Multiple Operations</a>.</p>
https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?comment=134473#post-id-134473Thanks Mike, multiple operations was exactly what I was looking for! Worked like a charm :DThu, 12 Oct 2017 20:14:25 +0200https://ask.libreoffice.org/en/question/134432/how-to-get-multiple-results-of-a-cell/?comment=134473#post-id-134473