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
|