Two formulas in one cell?

users
#1

In cell A2 the following formula
        is placed-=F30-2In the same cell (A2) I want to place a second formula which is
        =A10+4How 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

#2

=CONCATENATE(<1st formula>," ",<2nd formula>)

#3

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

#4

Thank you...I'll give it a try.

#5

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

#6

=3DTEXT(A3+3,NNNNMMMM D, YYYY)60;TEXT(A4,#####)

A3 was1/15/18 in my case and A4 was 27 result in cell is:

Thursday, January 18, 201827

Would be nice if you could put actually wanting with examples.

You can get the formating you need using the text command, and you can
see the diffiernt format option using the cell format, and it shows examples of
the format code. Just picked a longer one for the date format. Then just a

regular number format used for the second.

#7

Not sure why this list corrupts anything pasted directly from a spread sheet.
Looked fine when I sent it, but the result on list was WRONG??

Thursday, January 18, 2018 27
=TEXT(A3+3,"nnnnmmmm d, yyyy")&" "&TEXT(A4,"#####")

How it got

=3DTEXT(A3+3,NNNNMMMM D, YYYY)60;TEXT(A4,#####)

So copied it to a text editor, and then pasted it.

users@global.libreoffice.org,
  Carl Winerich <Look@iPadRing.net>
Date sent: Sun, 03 Jun 2018 11:44:39 +1000
Priority: normal

#8

That is an impressive solution from Michael but, not knowing the layout of your spreadsheet, I wonder why you cannot simply insert a new column adjacent to the cell in question so that each formula can be in a separate cell.

Regards MalJaros