Thread: IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lost Cluster Lost Cluster is offline
external usenet poster
 
Posts: 11
Default IF function

Im 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 Im using is: =IF(B1<"M",A1,"")
But its not working. Im trying to say that if ColB does not equal M
(Monday) then put the name from ColA under Monday.
Thanks