If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF function
I’m using the If Function to compare a string of text to a letter. This is
what I have ColA has names ColB has the days off in this format (string of text) Su/M/Tu-Th ColC-J have the days of the week Monday-Sunday. I want the names of Col A to appear in Col C-J if they work those days. So the If Function that I’m using is: =IF(B1"M",A1,"") But it’s not working. I’m trying to say that if ColB does not equal M (Monday) then put the name from ColA under Monday. Thanks |
#2
|
|||
|
|||
IF function
hi
you could use the wildcard character *. =if(B1="*M*",A1,"") regards FSt1 "Lost Cluster" wrote: I’m using the If Function to compare a string of text to a letter. This is what I have ColA has names ColB has the days off in this format (string of text) Su/M/Tu-Th ColC-J have the days of the week Monday-Sunday. I want the names of Col A to appear in Col C-J if they work those days. So the If Function that I’m using is: =IF(B1"M",A1,"") But it’s not working. I’m trying to say that if ColB does not equal M (Monday) then put the name from ColA under Monday. Thanks |
#3
|
|||
|
|||
IF function
The asterisks won't be treated as wildcards in that formula.
But =countif() does support wildcards: =if(countif(b1,"*M*")=0,A1,"") Or =find()/=search(): =if(iserror(find("M",b1)),a1,"") =find() is case sensitive =search() is not case sensitive FSt1 wrote: hi you could use the wildcard character *. =if(B1="*M*",A1,"") regards FSt1 "Lost Cluster" wrote: I’m using the If Function to compare a string of text to a letter. This is what I have ColA has names ColB has the days off in this format (string of text) Su/M/Tu-Th ColC-J have the days of the week Monday-Sunday. I want the names of Col A to appear in Col C-J if they work those days. So the If Function that I’m using is: =IF(B1"M",A1,"") But it’s not working. I’m trying to say that if ColB does not equal M (Monday) then put the name from ColA under Monday. Thanks -- Dave Peterson |
#4
|
|||
|
|||
IF function
Not sure whether this is what you are looking for…
If the First Character of B1 M =IF(TRIM(LEFT(B1,1))"M",A1,"") Or If you want to look B1 cell whether its having the character M in any case (Upper or Lower) =IF(ISNUMBER(SEARCH("M",B1))=FALSE,A1,"") Or If you want to look B1 cell whether its having the character M only in upper case. =IF(ISNUMBER(FIND("M",B1))=FALSE,A1,"") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Lost Cluster" wrote: I’m using the If Function to compare a string of text to a letter. This is what I have ColA has names ColB has the days off in this format (string of text) Su/M/Tu-Th ColC-J have the days of the week Monday-Sunday. I want the names of Col A to appear in Col C-J if they work those days. So the If Function that I’m using is: =IF(B1"M",A1,"") But it’s not working. I’m trying to say that if ColB does not equal M (Monday) then put the name from ColA under Monday. Thanks |
#5
|
|||
|
|||
IF function
and you're right. i did test but not the right way.
also tested.. =IF(MID(B2,4,1)="m",A2,"") =IF(FIND("M",B2,1)=4,A2,"") i should have posted those. thanks for the corrections. regards FSt1 "Dave Peterson" wrote: The asterisks won't be treated as wildcards in that formula. But =countif() does support wildcards: =if(countif(b1,"*M*")=0,A1,"") Or =find()/=search(): =if(iserror(find("M",b1)),a1,"") =find() is case sensitive =search() is not case sensitive FSt1 wrote: hi you could use the wildcard character *. =if(B1="*M*",A1,"") regards FSt1 "Lost Cluster" wrote: I’m using the If Function to compare a string of text to a letter. This is what I have ColA has names ColB has the days off in this format (string of text) Su/M/Tu-Th ColC-J have the days of the week Monday-Sunday. I want the names of Col A to appear in Col C-J if they work those days. So the If Function that I’m using is: =IF(B1"M",A1,"") But it’s not working. I’m trying to say that if ColB does not equal M (Monday) then put the name from ColA under Monday. Thanks -- Dave Peterson . |
Thread Tools | |
Display Modes | |
|
|