Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 09 Feb 2017 06:00:12 +0100How do I calculate a sum in a cell as well as showing text in the same cell?https://ask.libreoffice.org/en/question/87278/how-do-i-calculate-a-sum-in-a-cell-as-well-as-showing-text-in-the-same-cell/Just as the title suggests.
For example I want cell C1 to display the total of cells A1 ad B1, (=A1+B1) as well as some text unrelated to the calculation as well.
How would the formula look?
Each time I enter text anywhere in the cell (C1) it just screws up the calculation. I have tried putting it before and after the calculation, have tried using quotation marks too.
Can this be done, and if so, how?
Many thanks!appreciatethehelpThu, 09 Feb 2017 06:00:12 +0100https://ask.libreoffice.org/en/question/87278/