Having problem with a formula. What I am trying to say is...
if J2 equals 3042B OR 3042BP OR 304L2BP then in K2 I want 304/304L.
here is my formula
=IF(OR(J2="3042B",J2="3042BP",J2="304L2BP"),"304/304L")
Can anyone help.
Thanks in advance.
ishabir
if J2 equals 3042B OR 3042BP OR 304L2BP then in K2 I want 304/304L.
here is my formula
=IF(OR(J2="3042B",J2="3042BP",J2="304L2BP"),"304/304L")
Can anyone help.
Thanks in advance.
ishabir