Forum Discussion
emmanuel265
Mar 16, 2023Copper Contributor
What formula will translate 1 to "Male" and 2 for "Female"?
Hello guys, I have this huge list of names on my excel spreadsheet with gender identification as 1 representing Male and 2 for female, but then it is supposed to be written Male and Female instea...
Hecatonchire
Mar 16, 2023Iron Contributor
Hello
Only if it's for screen and print
Customize cells format number
[<2]"Male";"Female"