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