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
Hi Group,
In the attached excel sheet the maturity value is working fine for years
and months however it not giving me the exact result when it come to days
option.
Would you request to have look into this and provide appropriate solution.
Regards
Santosh
santoshkumar.subu...@gmail.com
--
FORU
...@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
s.com [mailto:excel-macros@googlegroups.com]
On Behalf Of santosh subudhi
Sent: Tuesday, December 27, 2011 2:03 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula correction needed for Recurring deposit
Hi Group,
Please look into the formula and do the necessary corre
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
>
> --
>
> ---
Hi,
Need help in formula...
I just need the only the first name to be extracted without space or gap...
Regards,
Jay S
8108932708
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
11 matches
Mail list logo
