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,