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+unsubscr...@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
