IF formula problem

[ishabir]

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

 

[Seti]

What is the problem you have this formula? Is the formula put in cell K2? You don't have a false condition either. What would you like to have in K2 if one of the 3 conditions on J2 is not met?

 

[Yesuslave]

I put that formula in and it worked fine. What are you getting?

 

[texasalynn]

It works for me. What kind of problem are you having?

texasalynn

 

[ishabir]

I am getting FALSE.

thanks

ishabir

 

[Yesuslave]

You'll get false if J2 doesn't equal any of your conditions. If you want to get something particular when the conditions are false, add another condition to the end, like this:
=IF(OR(J2="3042B",J2="3042BP",J2="304L2BP"),"304/304L", "Not a false statement")

 

[ishabir]

Ok, i have just realised what the problem is. J2 has trailing spaces which means the formula does not work.

I will sort that now.

Thanks.

ishabir