Hi everyone! Thank you in advance for the help with my question. My issue is i have a IF(OR statement that needs to nest over 7 but all the research i have done on how to fix it has not worked in my case. I am looking to compare shift codes to employee records and provide the description of the shift. Here is an example of my current formula...
=IF(OR(M3="X530",M3="0594",M3="0319",M3="PK16",M3="0333",M3="PK27",M3="0627",M3="0629",M3="PK05",M3="XIB2",M3="0011",M3="FD40",M3="COB1",M3="COB4",M3="CI27",M3="0345"),"Sun - Wed",IF(OR(M3="COB2",M3="0603",M3="0602",M3="0595",M3="0593"),"M,T,TH,F",IF(OR(M3="X531",M3="0596",M3="0321",M3="0604",M3="0334",M3="PK28",M3="0628",M3="0630",M3="PK06",M3="XIB4",M3="0012",M3="FD41"),"Wed - Sat",IF(OR(M3="COB5"),"M-TH",IF(OR(M3="0600",M3="0601",M3="0598",M3="0599"),"Sat-Sun",IF(OR(M3="0252",M3="AVQ7",M3="AVAO",M3="AVAJ",M3="COB3",M3="AVAL",M3="0373",M3="0109",M3="AVF1",M3="AAAA"),"Mon-Fri",IF(M3="","","Not Mapped")))))))
The formula is on the last column of the worksheet since i pull a report and paste in the results. Since the company i work for has no method to the madness of shift codes i cannot just change the shift codes to be for example 0001-0050 be a standard S-W code. So i need to have shift codes that are all over the place.
Thanks,
Rich
Bookmarks