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<[email protected]> wrote: >> >> From: James<[email protected]> >> Subject: [libreoffice-users] percentage to get number in Calc >> To: "libreoffice-users Mailing List"<[email protected]> >> 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: >> [email protected] >> 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: [email protected] 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
