Re: [libreoffice-users] how to have output in table from calc data?

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