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.