Long Nested IFs

[disturbed]

Hi Excel Wizzards !

I have this long nested IF that I was wondering.. does it need to be so darn long, or can it somehow be trimmed down with smarter formula?

=IF(RIGHT(F19,1)="B","HI RACK "&C19,IF(RIGHT(F19,1)="C","HI RACK "&C19,IF(RIGHT(F19,1)="D","HI RACK "&C19,IF(RIGHT(F19,1)="E","HI RACK "&C19,IF(RIGHT(F19,1)="F","HI RACK "&C19,"FLOOR "&C19)))))

I was thinking something like this would be nice:

=IF(RIGHT(F19,1)={"B","C","D","E","F"},"HI RACK "&C19,"FLOOR "&C19)

F19 is a position in a Pallet Rack. A is 'floor' level, B,C,D,E,F are overhead (hi rack) levels. C19 is the company code that owns the products.

[protonLeah]

It seems like everything is "HI RACK" unless its on the floor:

Please Login or Register  to view this content.

[disturbed]

It seems like everything is "HI RACK" unless its on the floor:

Damn.. you could almost end that with "DUH" !! Now that the light's shining in, I can't recall why I did all that "hi rack" stuff.. hmmm.

Anyway.. THANKS for pointing that out

[disturbed]

Just recalled why all the "hi racks".. there's other strings that make up floor as well.. mostly alpha/numeric but the problem is that A is not the only floor, and B,C,D,E,F are the only hi racks.

Is there no way to use if (A,B,C,D,E) as an OR statement?

I would like to write something like =IF(OR( if that makes sense.

< 10 minutes later >

I'm trying to get this to work now, I get a #VALUE! error:
=IF(RIGHT(F19,1)=OR("B","C","D","E","F"),"HI RACK "&C19,"FLOOR "&C19)

Am I asking for something that can't be done?

[DonkeyOte]

Very close - need to place the OR in the correct position:

Please Login or Register  to view this content.

[disturbed]

Very close - need to place the OR in the correct position:

Hooray!! That's exactly what I'm looking for.

Thanks very much!!