** Reply to message from Dave Liesse <[email protected]> on Wed, 27 Nov 2013 16:12:16 -0800
Dave, Thank you for the formula! I figured out how to enter it as a user function so it's easy to use. Thanks again. Cliff > 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 -- To unsubscribe e-mail to: [email protected] 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
