Re: [libreoffice-users] How do add percentage in Calc?

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:mail@revida.sk


--
For unsubscribe instructions e-mail to: users+help@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