** Reply to message from Dave Liesse <dsliesse@liessefamily.net> 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: 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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.