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

thanks.will try & let you know

On 6 August 2011 12:26, planas <jslozier@gmail.com> wrote:

> 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



-- 
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>

-- 
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