$$Excel-Macros$$ Re: Urgent Req: Macro or VBA Code for Compound Interest Algorithm

2009-06-16 Thread NIRAJ KOTHARI
here it is Function interest_cal(Principle As Double, rate As Double, days As Integer) Dim i As Integer Dim x As Double Dim y As Double Dim z As Integer Dim j As Integer Dim a As Double Dim a1 As Double Dim P1 As Double Dim d1 As Integer Dim interest_cal1 As Double Dim interest_cal2 As Double a1 =

$$Excel-Macros$$ Re: Urgent Req: Macro or VBA Code for Compound Interest Algorithm

2009-06-16 Thread obahor o
Hi Niraj: If you don't mind can you send the working code that Nishant helped u with. I am also having a problem getting it to work. I am also trying to do something similar. Thanks. Mog On Tue, Jun 16, 2009 at 3:49 AM, NIRAJ KOTHARI wrote: > > Thanks Nishant for your assistance its woring perfe

$$Excel-Macros$$ Re: Urgent Req: Macro or VBA Code for Compound Interest Algorithm

2009-06-16 Thread NIRAJ KOTHARI
Thanks Nishant for your assistance its woring perfectly fine.. Wish there is a rating system in this group where in we can give stars to best reply... Cheers Niraj On Sat, Jun 13, 2009 at 9:29 PM, Nishant Jain wrote: > > I have revised your file and have sent you an email... hope it will be >

$$Excel-Macros$$ Re: Urgent Req: Macro or VBA Code for Compound Interest Algorithm

2009-06-13 Thread Nishant Jain
I have revised your file and have sent you an email... hope it will be useful On Jun 13, 3:04 pm, NIRAJ KOTHARI wrote: > Hey Nishant > > Thanks for your efforts , your code looks absolutely perfect but i am unable > to make proper use of it. > >  i am herewith attaching a Sample Example of my da

$$Excel-Macros$$ Re: Urgent Req: Macro or VBA Code for Compound Interest Algorithm

2009-06-12 Thread Nishant Jain
I have tried to convert this for you... just check this out Sub interest(Principle As Double, rate As Double, days As Integer) Dim i As Integer Dim x As Double Dim y As Double Dim z As Integer Dim j As Integer Dim P1 As Double Dim d1 As Integer Dim interest1 As Double Dim interest2 As Double x =