Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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>  <drsoumalya@gmail.com>
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
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.