Re: [libreoffice-users] percentage to get number in Calc

Hi. A spreadsheet is a different way of working. At school we would have
learned 556.85 /646.15*100 to calculate the percentage but formatting in
the spreadsheet as a percentage saves multiplying by 100.
steve

On 2011-09-26 16:49, James wrote:
> On 09/25/11 23:10, Tom Davies wrote:
> > Hi :)
> > Ok, say the numbers are written along the top row such that
> >
> > A1 = 646.15
> > A2 = 556.85
> >
> > then
> >
> > A4 = A2/A1
> >
> > Click on A4 and go up to the menus at the top to choose
> >
> > Format - Cell - Number
> > in the first box "Category" select "Percentage"
> >
> > I think it's better to avoid keying in the currency symbol and just
> > format those cells as "Currency" instead of as "Percentages".  That
> > way you still get the currency symbol anyway but don't have to type
> > it in.  It also avoids confusions.  Note that i left a gap between
> > the data and the calculation purely because i think it looks nicer.
> Thanks for the solution.
> I feel stupid for making it seem hard. :-)
> >  
> > Regards from
> > Tom :)
> >
> >
> > --- On Mon, 26/9/11, James<bjlockie@lockie.ca>  wrote:
> >
> > From: James<bjlockie@lockie.ca>
> > Subject: [libreoffice-users] percentage to get number in Calc
> > To: "libreoffice-users Mailing List"<users@global.libreoffice.org>
> > Date: Monday, 26 September, 2011, 3:46
> >
> > I have a number $646.15
> > and a number $556.85
> > How do I make a formula in a new cell that is the percentage of the
> > first number that equals the second number?
> >
> >
> > -- 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

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