Thread: How do you define labels (e.g. 1 = male) in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default 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?


Reply With QuoteReply With Quote