Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the
word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
"Wildcard characters" - search for this term and it provides the explanation
you require -- Cheers Nigel "F. Lawrence Kulchar" wrote in message ... I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
I would test that formula once more.
Maybe you meant: =if(countif(a1,"*honda*")0,"is there","not there") F. Lawrence Kulchar wrote: I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
Why must you use the COUNTIF function?
Why NOT...=IF(A1="*honda*","there","not there") Thanks, FLKulchar "Dave Peterson" wrote: I would test that formula once more. Maybe you meant: =if(countif(a1,"*honda*")0,"is there","not there") F. Lawrence Kulchar wrote: I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
You don't _have_ to.
But it's one way of determining if honda is in A1 (even if it's surrounded by other characters). You could also use: =if(isnumber(search("honda",a1)),"there","not there") Change "search" to "find" if case is important. But wildcards won't work in this: =If(A1="*honda*", .... F. Lawrence Kulchar wrote: Why must you use the COUNTIF function? Why NOT...=IF(A1="*honda*","there","not there") Thanks, FLKulchar "Dave Peterson" wrote: I would test that formula once more. Maybe you meant: =if(countif(a1,"*honda*")0,"is there","not there") F. Lawrence Kulchar wrote: I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar -- Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
YOU ARE CORRECT...
WILDCARDS DO NOT WORK WITH...=IF(..... Do you know why or why not? FLKulchar "Dave Peterson" wrote: You don't _have_ to. But it's one way of determining if honda is in A1 (even if it's surrounded by other characters). You could also use: =if(isnumber(search("honda",a1)),"there","not there") Change "search" to "find" if case is important. But wildcards won't work in this: =If(A1="*honda*", .... F. Lawrence Kulchar wrote: Why must you use the COUNTIF function? Why NOT...=IF(A1="*honda*","there","not there") Thanks, FLKulchar "Dave Peterson" wrote: I would test that formula once more. Maybe you meant: =if(countif(a1,"*honda*")0,"is there","not there") F. Lawrence Kulchar wrote: I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
*Between*
I would imagine that the developers didn't want it to.
F. Lawrence Kulchar wrote: YOU ARE CORRECT... WILDCARDS DO NOT WORK WITH...=IF(..... Do you know why or why not? FLKulchar "Dave Peterson" wrote: You don't _have_ to. But it's one way of determining if honda is in A1 (even if it's surrounded by other characters). You could also use: =if(isnumber(search("honda",a1)),"there","not there") Change "search" to "find" if case is important. But wildcards won't work in this: =If(A1="*honda*", .... F. Lawrence Kulchar wrote: Why must you use the COUNTIF function? Why NOT...=IF(A1="*honda*","there","not there") Thanks, FLKulchar "Dave Peterson" wrote: I would test that formula once more. Maybe you meant: =if(countif(a1,"*honda*")0,"is there","not there") F. Lawrence Kulchar wrote: I know that the term If(A1=*honda*,"IS THERE","NOT THERE") searches for the word..."honda" anywhere within the text, etc., etc. I was explained this yesterday... HOWEVER, WHERE IN THE HELP MENU CAN I FIND THE EXPLANATION OF THIS?? Thanks, FLKulchar -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|