Formula to Determine if a String Value is Even or Odd

[jpstrzoch]

Greetings,

I have a warehouse storage location code. Example, "BUGG11F". This field is a string. I've used the following formula to return a portion of the location code. MID({Sheet1_.bin_num},5,2). This returns an "11" result, itself a string value.

How do I write a formula to consider whether the above formula result is either odd or even? In the example above, I would anticipate an "Odd", result because the string value when converted, using ToNumber would return the numeric value of 11, thus, Odd.

Let me know

Thanks!

 

[AndyMc]

if Remainder(val(MID({Sheet1_.bin_num},5,2)),2) = 0 then
"Even" else "Odd