Prev: If iserror help
Next: Need help with CountIF function
From: KEDIAANIL on 14 May 2010 10:41 PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT COMULATIVE INTREST RATE.
From: Brad on 14 May 2010 11:41 Lots of assumptions being made here =FV(0.04,(TODAY()A2)/365,0,B2) ..04 = assumed annual interest rate Today() = is the "as of" date of the calculation  this probably needs to be changes a2 = date payment b2 = the amount of payment Then sum up all the individual accumulations. using sum(range)  example =sum(c4:c300) There are several different "calculation" methods that could be used  this is a common one.  Wag more, bark less "KEDIAANIL" wrote: > PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT > COMULATIVE INTREST RATE. >
From: Fred Smith on 14 May 2010 14:13 People have to make too many assumptions to provide any help. You should clarify what you are looking for. An example would be good. And stop SHOUTING. Regards, Fred "KEDIAANIL" <KEDIAANIL(a)discussions.microsoft.com> wrote in message news:16F6B94EE40C424DB7250099861488A2(a)microsoft.com... > PLS HELP ME TO FIND FV FOR A PERIODICAL UNEQUAL INVESTMENT WITH A CONSTANT > COMULATIVE INTREST RATE. >

Pages: 1 Prev: If iserror help Next: Need help with CountIF function 