Re: [libreoffice-users] percentage to get number in Calc
Hi :) Hmm, i know BODMAS 'should' calculate that correctly but it's possible that a program or the person typing it in might incorrectly read an equation like that as = 556.85 / (646.15*100) Also any further calculations done using the correct percentage would have to remember to divide by 100 which could become cumbersome. It is good to know of different ways of handling a problem in case one way is troublesome for some reason that wasn't (or couldn't) be stated earlier in a thread. Regards from Tom :) --- On Mon, 26/9/11, Steve Edmonds steve.edmo...@ptglobal.com wrote: From: Steve Edmonds steve.edmo...@ptglobal.com Subject: Re: [libreoffice-users] percentage to get number in Calc To: users@global.libreoffice.org Date: Monday, 26 September, 2011, 4:58 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, Jamesbjloc...@lockie.ca wrote: From: Jamesbjloc...@lockie.ca Subject: [libreoffice-users] percentage to get number in Calc To: libreoffice-users Mailing Listusers@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+h...@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+h...@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+h...@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
[libreoffice-users] percentage to get number in Calc
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+h...@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
Re: [libreoffice-users] percentage to get number in Calc
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. Regards from Tom :) --- On Mon, 26/9/11, James bjloc...@lockie.ca wrote: From: James bjloc...@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+h...@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+h...@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
Fw: Re: [libreoffice-users] percentage to get number in Calc
Hi :) Ooops, i meant down the first column. Apols and regards from Tom :) --- On Mon, 26/9/11, Tom Davies tomdavie...@yahoo.co.uk wrote: From: Tom Davies tomdavie...@yahoo.co.uk Subject: Re: [libreoffice-users] percentage to get number in Calc To: users@global.libreoffice.org Date: Monday, 26 September, 2011, 4:10 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. Regards from Tom :) --- On Mon, 26/9/11, James bjloc...@lockie.ca wrote: From: James bjloc...@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+h...@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+h...@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
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, Jamesbjloc...@lockie.ca wrote: From: Jamesbjloc...@lockie.ca Subject: [libreoffice-users] percentage to get number in Calc To: libreoffice-users Mailing Listusers@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+h...@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+h...@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
Re: [libreoffice-users] percentage to get number in Calc
Hi :) Lol, these things happen. Possibly time for a quick break from the machine? Here it is soo late that it's not even early again anymore, beyond just being tomorrow and already well into today. Regards from Tom :) --- On Mon, 26/9/11, James bjloc...@lockie.ca wrote: From: James bjloc...@lockie.ca Subject: Re: [libreoffice-users] percentage to get number in Calc To: users@global.libreoffice.org Date: Monday, 26 September, 2011, 4:49 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, Jamesbjloc...@lockie.ca wrote: From: Jamesbjloc...@lockie.ca Subject: [libreoffice-users] percentage to get number in Calc To: libreoffice-users Mailing Listusers@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+h...@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+h...@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+h...@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
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, Jamesbjloc...@lockie.ca wrote: From: Jamesbjloc...@lockie.ca Subject: [libreoffice-users] percentage to get number in Calc To: libreoffice-users Mailing Listusers@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+h...@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+h...@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
