|
|
#1
06-04-2014, 05:43 AM
|
|||
|
|||
IF, ISNUMBER & AND function
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? 
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows XP 
Office 2010 32bit
Threaded Mode