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 |
Thread Tools | |
Display Modes | |
|
|