ael D. Setzer II"
To: "Brian Barker" , users@global.libreoffice.org,
"Carl Winerich"
Sent: Sunday, 3 June, 2018 03:44:39
Subject: Re: [libreoffice-users] Two formulas in one cell?
=3DTEXT(A3+3, D, )60;TEXT(A4,#)
A3 was1/15/18 in my case and A4 was 27 result i
nt: Sun, 03 Jun 2018 11:44:39 +1000
Subject: Re: [libreoffice-users] Two formulas in one cell?
Priority: normal
> =3DTEXT(A3+3, D, )60;TEXT(A4,#)
>
>
> A3 was1/15/18 in my case and A4 was 27 result in cell is:
>
>
> Thur
@global.libreoffice.org
From:60;Carl winerichl...@ipadring.net
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 fo
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 re
Thank you...I'll give it a try.
On 06/02/2018 05:49 PM, T. R. Valentine wrote:
> =CONCATENATE(<1st formula>,"",<2nd formula>)
>
> On 2 June 2018 at 16:20, . wrote:
>> In cell A2 the following formula
>> is placed-=F30-2In the same cell (A2) I want to place a second
>> formula which
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
=CONCATENATE(<1st formula>,"",<2nd formula>)
On 2 June 2018 at 16:20, . wrote:
> 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
>
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