How do you define labels (e.g. 1 = male) in excel?

[Guest]

I'd like to know if it's possible to add labels to data (e.g. 1 = male, 2 =
female) like you can in SPSS?

 

[Roger Govier]

Hi Anthony

Do you mean something like
=CHOOSE(A1+1,"n/a","male","female")