Re: [libreoffice-users] Two formulas in one cell?

Concatenate works...to a point.

Another problem is that first formula must provide a result formatted as
a date, let's say June 2.  The second formula must provide a result as a
day-number-of-the-year (which I haven't figured out how to do yet). 
Using concatenate the result is a 5 digit number returned for the first
formula even though the cell is formatted as a MMMM D.

How can these format requirements be maintained?

Thanks,

Carl


On 06/02/2018 06:10 PM, Brian Barker wrote:
> 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: users+unsubscribe@global.libreoffice.org
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