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 specified score index. > > Columns F, G, H, J, K, M, N, O, P, O, and R contain pure binomial > information (0 or 1) > Columns I, L, and S contain multiple numbered responses: > I = 0,1,3 > L = 0,1,2,3 > S = 0,1,2 > > I want to create a final score (Column T) based upon numerical responses > (in Columns F-S) > > Generally, scoring should happen like this for binomial answers, though > some responses are weighted more than others: > if F*=0 then T*=T*+0; else if F*=1 then T*=T*+1; > > Generally, scoring should happen like this for the columns containing > multiple answers, though again, some responses are weighted more than > others: > if I*=0 then T*=T*+0; if I*=3 then T*=T*+2; > > I'm sure this function is straightforward, but I have not even been able > to get the first column (F) to create a proper score for the final > column (T).
The if statement is documented in the help file. "if (logic conditional,true action, false action)" Regards, LesH -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
