formula
 

dear sir,

I have Prinicpal, amount & time how i am calculate rate of compound interst

formula
 

If:

A1 = Principal
B1 = Rate of Interest (percentage)
C1 = Number of Years

then

Amount accumulated = A1*(1+B1)^C1 (I think)

See http://math.about.com/library/weekly/aa042002a.htm

HTH

"pradeep" wrote:

dear sir,

I have Prinicpal, amount & time how i am calculate rate of compound interst

formula
 

http://www.meadinkent.co.uk/xlfinancial.htm

http://support.microsoft.com/?kbid=141695


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=539183