Sorting by Odd and Even by last digit in a account number

[rustynailed]

Hi All,

Im trying to make a formula that sorts odd by even numbers for customer account number focusing on the last last digit in the account number as the ref, The result is to be ODD or EVEN in a colmun. I cant seen to nail it down

=IF(EVEN(A2)=A2,"Even","Odd")

 

[dave3009]

Try

=IF(MOD(RIGHT(A2, 1), 2),"Odd","Even")

 

[yytsunamiyy]

Try:

=IF(EVEN(RIGHT(A2,1))=RIGHT(A2,1)+0,"EVEN","ODD")

 

[rustynailed]

Love it, thanks heaps