Very urgent. I have given my requirement in the attached excel sheet. Can somebody help me
S Suresh New Member Jan 28, 2015 #1 Very urgent. I have given my requirement in the attached excel sheet. Can somebody help me Attachments My requirement.xlsx 8.4 KB · Views: 8
Hui Excel Ninja Staff member Jan 28, 2015 #2 C2: =IF(OR(A2="A",A2="B",A2="C"),"One",IF(OR(A2="D",A2="E",A2="F"),"Two","Three")) Copy down Also note that Cell A5 has a "D " not a "D" in it
C2: =IF(OR(A2="A",A2="B",A2="C"),"One",IF(OR(A2="D",A2="E",A2="F"),"Two","Three")) Copy down Also note that Cell A5 has a "D " not a "D" in it