Hi :) It would be better to use a different cell for the result. For example A1 = 100 A2 = 2.9% A3 = A1 + A2
The problem with trying to make A1 = A1 + A2 is that if A1 started as 100 and A2 started as 2.9% then as soon as you hit enter A1 = 102.9 but then it would have to re-calculate because the A1 does not = 100 anymore so A1 = 105.8 but again it has to recalculate ... It is an iterative function http://en.wikipedia.org/wiki/Iterated_function How many iterations would you want and how fast would you want Calc to run through them? This is heading towards fractal dimensions and chaos theory. If you want to explore fractal dimensions and chaos theory then you really need something very different from a spreadsheet such as Calc or Excel. http://en.wikipedia.org/wiki/Iterated_function_system This game might help explain it http://en.wikipedia.org/wiki/Conway's_Game_of_Life The macro idea neatly gets around the problem by allowing a single iteration at a time. You have to apply it again in order to get the 2nd iteration or subsequent ones. The question is do you really need to create chaos? or can you just use a 3rd cell to give the result? Regards from Tom :) --- On Sat, 3/3/12, "Ing. Jiří Hladůvka" <m...@revida.sk> wrote: From: "Ing. Jiří Hladůvka" <m...@revida.sk> Subject: Re: [libreoffice-users] How do add percentage in Calc? To: users@global.libreoffice.org Cc: "PDA1" <pe...@aleksandrsolzhenitsyn.net> Date: Saturday, 3 March, 2012, 9:33 Or you can make a macro which makes the calculation and rewrites the contents of A1 with a new value. You can trigger the macro every time the value in A2 is changed. It should be very easy (using recording macro and data validation). Jiri Dne 3.3.2012 10:24, "Ing. Jiří Hladůvka" napsal(a): > Hi, > you can have in a cell A1 or a constant (value 100) or a formula (= > something *(1+a2) ) > > Best regards Jiri. > > > > > Dne 2.3.2012 22:59, PDA1 napsal(a): >> I have no idea how to add a percentage to a number in Calc. >> >> Example; >> >> Cell A1 has the number 100 >> >> Cell A2 has a percentage- 2.9% >> >> I want to add 2.9% to the number in A1 so that the answer is in cell A1. >> That is- 100 +2.9% >> (just for your reference- the percentage in A2 is always changing >> from my >> input) >> >> How in the world do I do it? >> >> >> >> >> >> >> -- >> View this message in context: >> http://nabble.documentfoundation.org/How-do-add-percentage-in-Calc-tp3794847p3794847.html >> Sent from the Users mailing list archive at Nabble.com. >> > > -- Ing. Jiří Hladůvka - REVIDA http://www.revida.sk mailto:m...@revida.sk -- 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
