Logical Functions
"PCLIVE" wrote:
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,
Thank you very much. This actually helped me clear up nesting issues.
|