(Msg. 1) Posted: Thu Sep 08, 2005 12:04 pm
Post subject: Repeat calculations Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
How can I perform a series of what I can only describe as circular
calculations? What I mean is I want to perform a calculation which
creates a particular result. I then want to perform that same
calculation using the newly created result and I’d like to perform that
process a certain number of times based on input from the user.
I also need to keep a running total of certain amounts calculated along
the way. The calculations I want to do stem from a basic amortization
calculation and I’d like to be able to calculate how much principal has
been paid after a certain number of payments are made, same with knowing
how much interest has been paid.
Using the –PMT(rate, nper, pv) formula, is it possible to keep track of
how much interest and principal has been paid after 30 payments with one
or two cells of formulas?
(Msg. 2) Posted: Thu Sep 08, 2005 12:34 pm
Post subject: Re: Repeat calculations [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Well, as what usually happens to me is once I ask the question, I'm able
to get over the mental block I have and find the answer myself. I failed
to take enough time to understand the CUMPRINC and CUMIPMT functions.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office