Did u try this formula.
Principle(1+rate/100)^month
Like
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:
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 this formula…
** **
** **
Principle(1+rate/100)^month
** **
Like
** **
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