Help with if condition

[proficient]

Hi all,

I have a column having digits like below; If the last number of cell is even I want female in very next cell else male

4220173438421
4220196875982
4220173485269
4220165478638

 

[wideboydixon]

Book1
	A	B
1	4220173438421	Male
2	4220196875982	Female
3	4220173485269	Male
4	4220165478638	Female
Sheet1

Cell Formulas
Range	Formula
B1	=IF(MOD(RIGHT(A1,1),2)=0,"Female","Male")

WBD