Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 14 Jul 2016 20:24:12 +0200CALC - Formula to Texthttps://ask.libreoffice.org/en/question/60999/calc-formula-to-text/ Hi, I want to use the calculated result of a cell formula as part of another formula.
So for example a cell calculates the reference of a cell containing a value (for example the calculation would display A4 as the result. I then want to use this value in another Formula, for example = COUNTIF(A4:A1,"S")
I don't want to manually copy and Paste Special but need a way to convert the formula in the first cell to a value and then use this as part of a second formula.Tue, 17 Nov 2015 15:23:01 +0100https://ask.libreoffice.org/en/question/60999/calc-formula-to-text/Comment by Unkuiri for <p>Hi, I want to use the calculated result of a cell formula as part of another formula.</p>
<p>So for example a cell calculates the reference of a cell containing a value (for example the calculation would display A4 as the result. I then want to use this value in another Formula, for example = COUNTIF(A4:A1,"S")</p>
<p>I don't want to manually copy and Paste Special but need a way to convert the formula in the first cell to a value and then use this as part of a second formula.</p>
https://ask.libreoffice.org/en/question/60999/calc-formula-to-text/?comment=62224#post-id-62224Hi,
For example if the result of a formula in C3 is A4 you can do:
CONCATENATE("=COUNTIF(";C3;":A1,'S')")
Maybe this could help...
But I can't seem to make libreoffice process the result as a formula...:(Wed, 23 Dec 2015 00:13:00 +0100https://ask.libreoffice.org/en/question/60999/calc-formula-to-text/?comment=62224#post-id-62224Answer by erAck for <p>Hi, I want to use the calculated result of a cell formula as part of another formula.</p>
<p>So for example a cell calculates the reference of a cell containing a value (for example the calculation would display A4 as the result. I then want to use this value in another Formula, for example = COUNTIF(A4:A1,"S")</p>
<p>I don't want to manually copy and Paste Special but need a way to convert the formula in the first cell to a value and then use this as part of a second formula.</p>
https://ask.libreoffice.org/en/question/60999/calc-formula-to-text/?answer=73298#post-id-73298Take a look at the `INDIRECT` function, for your example it would be something like `=COUNTIF(INDIRECT("A1:" & somecalculationthatreturnsa4asstring),"S")`
Thu, 14 Jul 2016 20:24:12 +0200https://ask.libreoffice.org/en/question/60999/calc-formula-to-text/?answer=73298#post-id-73298