if you place Male or Female in C1
in C2 enter
=if(C1="Male",Female","Male")
and copy down as far as you need

"Eden397" wrote:

Hi,
If I have a certain cell with text in it that I am hard coding as Female or
Male, and I want the next cell down to automatically state the opposite sex
than that cell, what logical function would I use?

Thanks,