2015 Archives by date, by thread · List index

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

```I hope this makes sense to you. I can do screen shots or give an example
.ods file.
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
2.10
3.10
4.30
4.40
2.20
13.70
5.50
3.70
2.80

\$39,583.73  =AVERAGE(B1:B11)         =SUM(A13*B13)

This example:
Where \$39,583.73 is cell A13
Where =AVERAGE(B1:B11) is cell B13 & should display 0.0429090909
Where =SUM(A13*B13) is cell C13 & should display \$1,698.50

I right clicked on B13 and selected "remove direct formating".

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