Thread: [Solved] IF, ISNUMBER & AND function
View Single Post
 
Old 06-04-2014, 06:09 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

=if(and(isnumber(search("asm",a4)),isnumber(search ("asm",a6))),1,"")
Reply With Quote