Hi On Sat, 2011-08-06 at 11:06 +0530, soumalya ray wrote:
> hi, > i searched for this but since i am totally new to calc i could not even > understand what to search for. > i have calc sheet named "students demography" with the > name,age,gender,wt,height,BMI,sponsored candidate or not etc.now i need to > make tables for comparing the data.say the row header contains *BMI >30 & > BMI <30* and the column of the table contains *male & female*. > what is the way to have this output from the calc data? > @tomdavies i am attaching a proforma of the calc sheet and the expected > output. > any help will be highly appreciated.thanks in advance > > > -- > Dr soumalya ray <http://drsoumalya.blogspot.com> <[email protected]> > MBBS,MD(PGT)C.Medicine,Ex-HousePhysician(Medicine) > Skype: som3776 | Twitter: @docbkp <http://twitter.com/docbkp> > It sounds like you need to columns if statements to select the data needed. The if statement format is =if(condition=true,true statement/action,false statement/action). For example column d has the BMI data, a possible if statement is =if(d2>30,D2,""). The execution is to determine if the value in D2 is greater than 30, if true copy the value of D2 into the cell and if false enter nothing. The last is a method so you have a column of numbers and empty cells for functions like sum, average. If you need to reference a cell on another sheet you use this notation sheetname.cell or if you are referencing cell b3 on sheet3, sheet3.b3. and in the formula =if(sheet3.b3>34,something,something else) If you leave the true action or more commonly the false action, the result in the cell will be TRUE or FALSE. Example, =if(b2>35,,a2+b2) and =if(b2<35,a2+b2). In the first example your answer is TRUE or a2+b2 and in the second is a2+b2 or FALSE. The TRUE and FALSE are Boolean values not characters, a common trait in spreadsheets and one that catch new users. If you want a text value you must use "true" and "false" (upper case if desired). Note also, in the second example the false clause was omitted but there must be a true clause. -- Jay Lozier [email protected] -- 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
