2012 Archives by date, by thread · List index

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

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

From: "Ing. Jiří Hladůvka" <mail@revida.sk>
Subject: Re: [libreoffice-users] How do add percentage in Calc?
To: users@global.libreoffice.org
Cc: "PDA1" <peace@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:
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

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