In A2:

=IF(A1="Male","Female",IF(A1="Female","Male",""))

HTH,
Paul

"Eden397" wrote in message
...
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,