rustynailed
Board Regular
- Joined
- Sep 29, 2008
- Messages
- 64
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")
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")