2012 Archives by date, by thread · List index

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

```2012/3/2 PDA1 <peace@aleksandrsolzhenitsyn.net>:
```
```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: 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
```