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

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?

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

Hi Anthony

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

--
Regards

Roger Govier


"Anthony" wrote in message
...
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?