2013 Archives by date, by thread · List index

# Re: [libreoffice-users] Question

```
https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_FV_function

On 11/27/2013 07:12 PM, Dave Liesse wrote:
```
I've had troubles in the past finding specific financial functions, as well. Can't help from the function standpoint in this case, but you could always fall back on the actual equation:
```
FV = PV*(1+i)^n

```
where FV is future value, PV is present value, i is the periodic interest rate, and n is the number of periods.
```
Dave

On 11/27/2013 15:10, Cliff Scott wrote:
```
I haven't done much spread sheet formula work so please don't mind a couple
```of simple questions.

I would like to do two things:

1. Calculate compound interest on an amount given the rate and number of
```
interest periods. Looking at the list of functions there are lots of ones that come close to that, but I wasn't able to find one that would do exact
```that.

2. How do I write a conditional loop in Calc? If I want to calculate a
formula for 10 iterations how would I do that? For instance
```
Value=Value*N+Value. That would give me the compound interest also. I can do
```it with a bunch of cells strung out each one representing one interest
period, but for any length of time it becomes unwieldy.

Thank you very much for any help.

Cliff

```
```

```
```
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php

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