Oh yes, thank you very much both you, it´s excellent, the more it´s simplified the better, i put in a formula with various conditions!1000 thanks :)
2011/3/7 OpenExcel.com <ashishj...@openexcel.com> > Hi Jorge, > > > If you want to further reduce your formula size, you can use > =IF(((P3>T3)+(Q3>U3)+(R3>V3)+(S3>W3))>=2,TRUE,FALSE) > > > I only modified Paul's formula. So, Thanks Paul. > > > > > ------------------------------ > Excel VBA Interview > Questions<http://www.excelitems.com/2010/12/excel-vba-interview-questions.html> > Collection of Excel VBA > Macros<http://www.excelitems.com/2008/09/vba-macro-codes-examples-collection.html> > > VLOOKUP<http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html> > > OFFSET<http://www.excelitems.com/2011/01/use-offset-function-dynamic-range.html#more> > ARRAY > formulas<http://www.excelitems.com/2010/06/array-or-cse-formulas-and-functions-in.html> > > ------------------------------ > Excel 2003 Style Menu in Excel > 2007<http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> > Custom Number > Format<http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html> > > SUMIFS<http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html> > CONTACT a > TRAINER<http://www.excelitems.com/2009/03/callcontact-trainer-for-excelvbavsto.html> > > <http://www.excelitems.com/2010/12/excel-2003-style-menu-in-excel-20072010.html> > ------------------------------ > > > > > > Thanks & Regards > ------------------------------ > Ashish Jain > (Microsoft Certified Application Specialist) > (Microsoft Certified Professional) > http://www.excelitems.com > http://www.openexcel.com > > Facebook <http://www.facebook.com/eXceLiTems> > Twitter<http://www.twitter.com/eXceLiTems> > LinkedIn <http://in.linkedin.com/in/ashishjain08> > LiveJournal<http://livejournal.excelitems.com/> > Digg <http://digg.com/excelitems> > Delicious<http://www.delicious.com/save?new=1&url=http%3A%2F%2Fwww.excelitems.com%2F&title=MS%20Excel%20VBA%20%26%20VSTO%20Macros%2C%20Functions%2C%20Tutorials%20%26%20Downloads&type=BOOKMARK&jump=http://www.delicious.com%2Fmountint&key=Nyn3Hc9oMaEzmGO_Fg_jkAwe1hI-©user=mountint&via=mountint©tags=eXceLitems+Office+Microsoft+Functions+Formulas+VBA+VSTO+Excel2010+Excel2007+excel2003+Excel+Bookmarks_Menu+eXceLiTems.com> > Subscribe by > Email<http://feedburner.google.com/fb/a/mailverify?uri=excelitems> > ------------------------------ > > -- > > ---------------------------------------------------------------------------------- > 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
