Tom Davies wrote:
Hi :)
Don't self referencing equations usually tend towards chaos and have fractal dimensions? It's a bit beyond the scope of a spreadsheet! Is there a way of limiting the number of iterations or does Calc just protect it self (and the cpu) from calculations running away to
ards chaos?
Regards from
Tom :)
--- On Fri, 21/9/12, Tim Deaton wrote:
From: Tim Deaton
Subject: Re: [libreoffice-users] Help with Scoring Bi-nominal Responses
To: "Paul Anderson" , "users@global.libreoffice.org"
Date: Friday, 21 September, 2012, 21:26
As others have
As others have stated, "T2=T2+..." will fail, because it references its
own result.
For this example, you might put this in T2:
=IF(OR(F2=0,L2<3),0,F2+L2)
Translation:
1. If F2=0, then T2=0
2. If L2 is less than 3, then T2=0
3. If F2 is greater than 0 and L2 is greater than 2, then T2=(F2+
On Fri, 2012-09-21 at 00:34 -0500, Paul Anderson wrote:
> Thanks to all for the previous help,
>
> Also, sorry if you have addressed this already, Brian. But, I know only
> basic functions within the spreadsheet and will request a more
> explanatory example.
> The file was delivered in xlsx form
How about:
T2 = 4 * (F2 AND (L2=3))
On 21 September 2012 06:34, Paul Anderson wrote:
> Thanks to all for the previous help,
>
> Also, sorry if you have addressed this already, Brian. But, I know only
> basic functions within the spreadsheet and will request a more explanatory
> example.
> The f
Hi Paul,
(replied received on my personal mailbox -- as I think this might be by
mistake, I answer on the list also)
Le 21/09/2012 07:18, Paul Anderson a écrit :
Also, sorry if you have addressed this already, Brian. But, I know only
basic functions within the spreadsheet and will request a
Thanks to all for the previous help,
Also, sorry if you have addressed this already, Brian. But, I know only
basic functions within the spreadsheet and will request a more
explanatory example.
The file was delivered in xlsx format. I would like to maintain the
format (using LibreOffice!), but
Le 19/09/2012 07:03, Paul Anderson a écrit :
Hello all,
I have a simple question for which I cannot find the answer.
I have a LibreCalc spreadsheet containing binomial data for which I
would like to create a final summed "score" (in Column T) based upon a
manually specified score index.
Column
On Wed, 2012-09-19 at 00:03 -0500, Paul Anderson wrote:
> Hello all,
>
> I have a simple question for which I cannot find the answer.
>
> I have a LibreCalc spreadsheet containing binomial data for which I
> would like to create a final summed "score" (in Column T) based upon a
> manually speci
At 00:03 19/09/2012 -0500, Paul Anderson wrote:
I have a LibreCalc spreadsheet containing binomial data for which I
would like to create a final summed "score" (in Column T) based upon
a manually specified score index.
Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial
informat
Hello all,
I have a simple question for which I cannot find the answer.
I have a LibreCalc spreadsheet containing binomial data for which I
would like to create a final summed "score" (in Column T) based upon a
manually specified score index.
Columns F, G, H, J, K, M, N, O, P, O, and R conta
11 matches
Mail list logo