R Robo Jul 21, 2004 #1 I would like a formula that would give a result "Yes" or "No" if a tex field contained the word Tower, is this possible? Thank
I would like a formula that would give a result "Yes" or "No" if a tex field contained the word Tower, is this possible? Thank
H hgrove Jul 21, 2004 #3 Jason Morin wrote... =IF(A1="Tower","Yes","No") ... -----Original Message----- Click to expand... The word 'contained' in the OP is ambiguous. It could also mean =IF(COUNTIF(A1,"*Tower*"),"Yes","No"
Jason Morin wrote... =IF(A1="Tower","Yes","No") ... -----Original Message----- Click to expand... The word 'contained' in the OP is ambiguous. It could also mean =IF(COUNTIF(A1,"*Tower*"),"Yes","No"
J Jason Morin Jul 21, 2004 #4 It's not ambiguous to me. -----Original Message----- Jason Morin wrote... possible? The word 'contained' in the OP is ambiguous. It could also mean =IF(COUNTIF(A1,"*Tower*"),"Yes","No") Click to expand...
It's not ambiguous to me. -----Original Message----- Jason Morin wrote... possible? The word 'contained' in the OP is ambiguous. It could also mean =IF(COUNTIF(A1,"*Tower*"),"Yes","No") Click to expand...
H hgrove Jul 21, 2004 #5 Jason Morin wrote... It's not ambiguous to me. Click to expand... ... Does the phrase 'Tower of Ignorance' *contain* the word Tower
Jason Morin wrote... It's not ambiguous to me. Click to expand... ... Does the phrase 'Tower of Ignorance' *contain* the word Tower
J John Woodgate Jul 21, 2004 #6 I read in microsoft.public.excel.worksheet.functions that hgrove Jason Morin wrote... .. Does the phrase 'Tower of Ignorance' *contain* the word Tower? Click to expand... Does the phrase 'Tower of barges'? (;-)
I read in microsoft.public.excel.worksheet.functions that hgrove Jason Morin wrote... .. Does the phrase 'Tower of Ignorance' *contain* the word Tower? Click to expand... Does the phrase 'Tower of barges'? (;-)
