If I create a formula for a cell, in that cell, I can't add any data to make
the formula work as it erases the formula.

Example - I want "1" to change to "Male" and "2" to change to "Female".
I've created the formula no problem but I need the data to be reflected in
the cell in which I have created the formula. Is that even possible?