Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

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: .

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:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.