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