Formula for odd or even numbers

[brandonp]

Basically I have one column full of numbers that have text in them (40N006), so I trimmed the last digit to the next column over. Now how do I either use a formula or conditional formatting to output to the next column if the number that was trimmed is an even or odd? It seems simple, but i can't get it. Please help!

[Ruthki]

try

=IF(ISODD(A1),A1,"")

you can also use ISEVEN

r

[VBA Noob]

Try this

Then you won't need column Column

=IF(ISEVEN(RIGHT(A1,1)),"",RIGHT(A1:A1,1))

if you need the helper column try

=IF(ISODD(B1),B1,"")

VBA Noob

[brandonp]

Thanks guys! Worked like a charm!