for excel 2003
=IF(ISERROR((ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2))),"",(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2)))
On Sun, Jan 22, 2012 at 10:37 AM, Nikhil Shah wrote:
> Hi sam,
>
> Can you post in Excel
Hi sam,
Can you post in Excel 2003 ? ..I am using excel 2003
Regards
Nikhil Shah
On Sat, Jan 21, 2012 at 10:56 PM, Sam Mathai Chacko wrote:
>
> =IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2),"")
>
> Regards,
>
> Sam Mathai Chacko
>
> On Sat, Jan 21
=IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7="Months",(F7/12),IF(E7="Years",F7,F7/365))),2),"")
Regards,
Sam Mathai Chacko
On Sat, Jan 21, 2012 at 5:25 PM, santosh subudhi
wrote:
> Hi Group,
>
> In the attached excel sheet the maturity value is working fine for years and
> months however it no
...@lovetour.info; excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula correction needed for Recurring deposit
Hi Asaf,
Please find below the link I am referring to.
http://www.allbankingsolutions.com/Recurring-Deposit-Calculator-India.shtml
You are right!!!
The correct
@googlegroups.com
Subject: RE: $$Excel-Macros$$ Formula correction needed for Recurring
deposit
Date: Tue, 27 Dec 2011 13:03:08 -0800
Hi Santosh,
Assuming the value you have labeled ROI and I is really just ROI (remember,
your graphic indicates that i=ROI/400), you can replicate the formula in
your
Hi Santosh,
Assuming the value you have labeled ROI and I is really just ROI (remember,
your graphic indicates that i=ROI/400), you can replicate the formula in
your graphic like this:
=(I4*((1+I6/400)*I5-1))/(1-(1+I6/400)-1/3)
The result is -31751. Surely not what you hoped.
I think the
Dear Jay,
Problem is solved. See the attachment.
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Jay
Try putting the following formula in cell C3:
=LEFT(B3,FIND(" ",B3,1))
Norman
On Wed, Aug 25, 2010 at 4:56 AM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Dear Lucky,
Please find attachement with solution.
Thanks,
Noorain Ansari
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> ---
