Thanks, I got it to work and it cleared up my issues. But it lead me to one
other question....Here is my formula:
=IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664 !C11="quota","0",IF(Combo_4_000664!C11="222","1")) )

but I am getting a "FALSE" when I enter 222 in my linked spreadsheet. I
believe it's because I am already using a "1" for my All case, so does anyone
know how to rewrite this to clean it up. I really appreciate this help,
everyone.

"PCLIVE" wrote:

Did you try your formula? You've written it using semi-colons (;) instead
of commas (,).

Anyway, the formula is cleaner if you test for blank first.
=IF(A1="","",IF(A1="Female","Male","Female"))

Regards,
Paul



"Erny" wrote in message
...
Example if certain cell is A1:
In A2, formula is:
=IF(A1="Male";"Female";IF(A1="Female";"Male";""))
(If A1 is not "Male" or "Female" then the cell will not display anything
with the above formula.)

Kind regards,
Erny

"Eden397" schrieb im Newsbeitrag
...
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,