IF, ISNUMBER & AND function

Dkline · #1 06-04-2014, 05:43 AM

This is the formula I've come up with

=IF(AND(ISNUMBER(SEARCH("ASM",A4))),"1",IF(AND(ISN UMBER(SEARCH("ASM",A6)),"1","")))

I basically want to look at 2 cells and if they both contain ASM I want to place a 1 in col B if not then it can be blank or na or anything other then a 1.

Any suggestions how to fix this?

gebobs · #2 06-04-2014, 06:09 AM

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

Dkline · #3 06-04-2014, 06:33 AM

You Sir... or Ma'am happen to be awesome.

Thanks!

gebobs · #4 06-04-2014, 06:40 AM

I keep telling my wife...or husband...that.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Creating a graph for Future Value function (FV function)	bmoody	Excel	2	11-06-2013 10:52 AM
IF function	msheyworth	Excel	2	03-28-2013 02:15 AM
Sum Function	teza2k06	Excel	3	02-06-2013 08:29 AM
how to use now() function	gsrikanth	Excel	1	01-07-2012 01:18 AM