2012/3/2 PDA1 <[email protected]>: > 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?
How do you mean? 1: A1=100, A2=2.9% → A1 changes to 102,9 2: You enter 3% in A2, A1 now changes to what? 103 or 105,987? If 103, enter 100 in a hidden cell, let's say A3 and then let A1=A3*(1+A2), or as a constant in A1, that is A1=100*(1+A2). If you want A1 to change its value by Itself·(1+A2) every time you enter a new value in A2, then you could use a macro for that, but how ever you do it, you are very likely to shoot yourself in the foot. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- 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
