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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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