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

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