Prev: how do I turn the screen off during macro execution
Next: Trouble with Pivot Tables & Named Ranges
From: colin devine colin on 4 Mar 2010 17:56
I want to be able to set an interest rate, fix a monthly budget, set a
baloon/final payment, so that i can see clearly how much depost i've got left
against a new
From: Fred Smith on 4 Mar 2010 23:44
Your description leaves a lot to be desired.

What do you want to calculate? The monthly payment? The initial amount? What
does "got left against a new" mean?

You will want a financial function. You can check out the functions PV, FV,
NPER, or PMT. One of these will do what you want.

Or, post back with a clearer explanation of what you want to do. An example
would be extremely useful.

Regards,
Fred

"colin devine" <colin devine(a)discussions.microsoft.com> wrote in message
news:71849149-240B-45FD-9613-3A0F90927A29(a)microsoft.com...
>I want to be able to set an interest rate, fix a monthly budget, set a
> baloon/final payment, so that i can see clearly how much depost i've got
> left
> against a new

 | 
Pages: 1
Prev: how do I turn the screen off during macro execution
Next: Trouble with Pivot Tables & Named Ranges