Dear member plz help me
**
I am calculating compound interest on loan over a period where interest is
compounded either Monthly, Quarterly, Semi- Annually and Annually.
But it is stands valid in case of Non- leap years. Please give me a
formulae for leap years.
** **
*Regards,*
@googlegroups.com
Subject: $$Excel-Macros$$ EX-QUERY
Dear member plz help me
I am calculating compound interest on loan over a period where interest is
compounded either Monthly, Quarterly, Semi- Annually and Annually.
But it is stands valid in case of Non- leap years. Please give me a formulae
** **
500(1+5/100)^5
** **
* *
*Warm Regards,*
*Ravi Kumar.*
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *sridher sharma
*Sent:* Monday, September 09, 2013 4:08 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ EX
2013 16:22:16
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ EX-QUERY
yes i used this formula
but it is stands valid in case of Non- leap years, Please give me
a formula for leap years.
On 9 September 2013 16:18, Ravi Kumar excellearn2
: * sridher sharma sridher.sha...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Mon, 9 Sep 2013 16:22:16 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ EX-QUERY
yes i used this formula
but it is stands valid
@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ EX-QUERY
yes i used this formula
but it is stands valid in case of Non- leap years, Please give me
a formula for leap years.
On 9 September 2013 16:18, Ravi Kumar excellearn2...@gmail.com wrote:
Did u try
--
*From: * sridher sharma sridher.sha...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Mon, 9 Sep 2013 16:22:16 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ EX-QUERY
yes i used this formula