At 17:20 02/06/2018 -0400, Dotty Carl Noname wrote:
In cell A2 the following formula is placed =F30-2 In the same cell
(A2) I want to place a second formula which is =A10+4 How can I add
this second formula into A2 and obtain the results of both formulas
in the same cell (A2) but each separated by several spaces so the
results are distinct? Thank you, Carl
The answer to this question is very similar to that for the almost
identical question that you asked (and had answered) last November 21st:
http://document-foundation-mail-archive.969070.n3.nabble.com/Formula-and-text-in-same-cell-td4227487.html
.
If a cell contains a formula, the result of that formula is what
appears in the cell, so having two formulae would be simply
contradicting yourself. As you already know, if you wanted F30-2 you
would not expect to use =F30 and then =-2 separately but instead
=F30-2. In the same way, you must construct a single formula that
creates the combination of values that you ask for. You can combine
results using the CONCATENATE() function or, more simply, the "&"
operator. Try:
=F30-2&" "&A10+4
Incidentally, do please put your name in the real name field of your
mail messages: it's an elementary courtesy to those offering to help you.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
