Formula giving same returned value (If Else)

[Karl_Spratt]

Hi Folks, I have to identify what items should fit into which storage bin locations, I have the bin / plt sizes but when I create the If Else Formula, all my data is returning BIN 1 can anyone help?  TIA Karl

[CKP · Accepted solution]

Hi @Karl_Spratt 

I think you just need to replace '+' with 'AND' and it should work.

Example

[Height1]<=10 AND [Width1]<=8.5

[Karl_Spratt]

Thanks CPK that worked