If(Or(Rght(.......) formula won't work

[mab1284]

Why won't the following formula work:

=IF(OR(RIGHT(B1,3)="601","610","615"),"MfrgPart","VendorPart")

My part #s are ABCD101, DCEF601, the last three digits are always the reference to mfrg part or vendor part.

Any help would be appreciated.

 

[Scott Huish]

=IF(OR(RIGHT(B1,3)={"601","610","615"}),"MfrgPart","VendorPart")

 

[VoG]

Try

=IF(OR(RIGHT(B1,3)="601",RIGHT(B1,3)="610",RIGHT(B1,3)="615"),"MfrgPart","VendorPart")

 

[Aladin Akyurek]

Why won't the following formula work:

=IF(OR(RIGHT(B1,3)="601","610","615"),"MfrgPart","VendorPart")

My part #s are ABCD101, DCEF601, the last three digits are always the reference to mfrg part or vendor part.

Any help would be appreciated.

Try...

=IF(ISNUMBER(MATCH(RIGHT(B1,3)+0,{601,610,615},0)),"MfrgPart","VendorPart")

 

[mab1284]

=IF(OR(RIGHT(B1,3)={"601","610","615"}),"MfrgPart","VendorPart")

Thank you so much. Just another question because I can't find the answer in the Excel reference book I have, what do the {} mean? The formula worked but for future I would like to know what the { } brackets do?

 

[mab1284]

Try...

=IF(ISNUMBER(MATCH(RIGHT(B1,3)+0,{601,610,615},0)),"MfrgPart","VendorPart")

Thank you much. I see your formula also includes the { } brackets as well as the ( ). Don't see any reference to { } in my Excel book so maybe I need to get a more advanced book.

 

[Aladin Akyurek]

Thank you much. I see your formula also includes the { } brackets as well as the ( ). Don't see any reference to { } in my Excel book so maybe I need to get a more advanced book.

{601,610,615}

is an array constant. It would be identical to a range housing these values in cells of their own, say, X2:X4, with X2 = 601, X3 = 610, and X4 = 615.

We can now invoke equivalently:

=IF(ISNUMBER(MATCH(RIGHT(B1,3)+0,$X$2:$X$4,0)),"MfrgPart","VendorPart")