2015 Archives by date, by thread · List index

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

```At 17:33 14/02/2015 +0000, Ronnie Ronly wrote:
```
I wanted to take a fixed dollar amount, an average of percentages and the dollar amount from the sum of the average. In other words: I am given \$39,583.73 and based on 4.29% I receive \$1,698.50
```
(Curr. Fmt)  (% FMT)
Column A     Column B                Column C
2.30
3.10
...

\$39,583.73  =AVERAGE(B1:B11)   =SUM(A13*B13)
```
```
Er, so what is the question, please?

```
```This example:
Where \$39,583.73 is cell A13
```
```
```
Your currency vales in column A should be entered as numbers, without the \$ sign or the comma (and not as text), and formatted as Currency. Is that what you have?
```
```
```Where =AVERAGE(B1:B11) is cell B13 & should display 0.0429090909
```
```
```
The average of the numbers you have supplied is 4.29, of course, not 0.429 - which is 4.29%. The best way to handle column B is to format the column *first* as Percent and then enter the values as numbers - 2.30 and so on - so that the display is 2.30% but the actual numerical value stored will be 0.023 and so on: the actual fractions that you need. If these were genuinely formatted as Percent you would see % signs, so it seems that you have not done this.
```
```
```Where =SUM(A13*B13) is cell C13 ...
```
```
```
I understand =A13*B13 - but you are trying to sum this with nothing! SUM() means "add all these up", not just "please do a calculation for me". Use just =A13*B13 .
```
```
```... & should display \$1,698.50
```
```
```
If you do as above and format column C (or just cell C13) as Currency, that is indeed what you should see.
```
I trust this helps.

Brian Barker

--
To unsubscribe e-mail to: users+unsubscribe@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
```