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