hi frds,
below is my query,
I have set of 16 digits numbers in a column. there is a another column based on this column. Let the columns be C & D. Baed on the last 2 digits of the column c , column D value should get changed.
I have following conditions.
if the no ends with
22 ---- AAAA
33-----BBBB
44-----CCCC
55----GGGG
i used the following condition using right and if. but it didnt work. can any one help me pls..
=IF(RIGHT(C2,2)=F3,G3,IF(RIGHT(C2,2)=F4,G4,IF(RIGHT(C2,2)=F6,G6,"Not Listed")))
below is my query,
I have set of 16 digits numbers in a column. there is a another column based on this column. Let the columns be C & D. Baed on the last 2 digits of the column c , column D value should get changed.
I have following conditions.
if the no ends with
22 ---- AAAA
33-----BBBB
44-----CCCC
55----GGGG
i used the following condition using right and if. but it didnt work. can any one help me pls..
=IF(RIGHT(C2,2)=F3,G3,IF(RIGHT(C2,2)=F4,G4,IF(RIGHT(C2,2)=F6,G6,"Not Listed")))