Hi SB, Please Have a look on below links...you may get idea about Nested formulas.. http://www.techonthenet.com/excel/formulas/if_nested.php
http://www.experiglot.com/2006/12/11/how-to-use-nested-if-statements-in-excel-with-and-or-not/ http://www.ozgrid.com/Excel/free-training/excel-lesson-37-basic.htm -- *Best Regards,* *Venkat* *Chennai* * * On Tue, Aug 2, 2011 at 5:41 PM, shashank bhosle < catchshashankbho...@yahoo.co.in> wrote: > Hi Venkat, > > > Thank , thank you very much. Also help me, how you nest this formula. Any > pattern i need to follow. > > Again Thank you! > > Regards > SB > > ------------------------------ > *From:* Venkat CV <venkat1....@gmail.com> > > *To:* excel-macros@googlegroups.com > *Cc:* catchshashankbho...@yahoo.co.in > *Sent:* Tuesday, 2 August 2011 5:37 PM > *Subject:* Re: $$Excel-Macros$$ > > Hi SB, > > Find attached your query resolved....if anything else u want Just attach > sample workbook.. > *Best Regards,* > *Venkat* > *Chennai* > > > On Tue, Aug 2, 2011 at 4:54 PM, shashank bhosle < > catchshashankbho...@yahoo.co.in> wrote: > > Hello All > > I want a formula who will give me as such > if country = India and Code lenght is greater than 10 than give me error. > > Regards > SB > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > * > * > * > * > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > * * * * -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
