I am trying to write a simple true false formula but am running into some issues.
I work in the warehouse environment and need to separate some of my bins from even and odd. I know how to write the formula to create a true false statement based on the number being even or odd (Example: =iseven(A1)). the end result being every even number will display true and every odd will display false.
The problem I am having is I am looking at my bin locations and they include not only a number but a letter as well. (Example- 45N001). It is the letter that is throwing off the formula. When I use the same formula i get (#value!) instead of the true false I am looking for.

Does anyone know how to write a formula to either include the letter or exclude the letter from the formula and still get a true false response?