bj,

Your formula is missing a Quote before Female. Anyway, to keep the cell
from populating when nothing is in the cell above, an additional statement
is needed. Where A1 is the cell to enter Male or Female:

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

Regards,
Paul


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