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. On 3 Jun 2018 at 11:44, Michael D. Setzer II wrote: From: "Michael D. Setzer II" <[email protected]> To: Brian Barker <[email protected]>, [email protected], Carl Winerich <[email protected]> Date sent: Sun, 03 Jun 2018 11:44:39 +1000 Subject: Re: [libreoffice-users] Two formulas in one cell? Priority: normal > =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. > > > > > On 2 Jun 2018 at 20:54, Carl Winerich wrote: > > > To:;Brian [email protected], > [email protected] > From:60;Carl [email protected] > Subject:;Re: [libreoffice-users] Two formulas in one cell?Date sent:60;Sat, 2 > Jun 2018 20:54:49 -0400 > > > 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:</font> > =F30-260;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 > > > > > -- > 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 > +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:[email protected] mailto:[email protected] Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS ROSETTA 65563610.075728 | ABC 16613838.513356 SETI 109375858.605587 | EINSTEIN 141133906.999240 -- 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
