Logical Functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eden397 - 08 Jun 2007 18:32 GMT

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,

Reply to this Message

PCLIVE - 08 Jun 2007 18:38 GMT

In A2:

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

HTH,
Paul

> Hi,
> If I have a certain cell with text in it that I am hard coding as Female
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message

Eden397 - 08 Jun 2007 18:48 GMT

> In A2:
>
[quoted text clipped - 13 lines]
>
> Thank you very much. This actually helped me clear up nesting issues.

Reply to this Message

bj - 08 Jun 2007 18:40 GMT

if you place Male or Female in C1
in C2 enter
=if(C1="Male",Female","Male")
and copy down as far as you need

> 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,

Reply to this Message

PCLIVE - 08 Jun 2007 18:46 GMT

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

> if you place Male or Female in C1
> in C2 enter
[quoted text clipped - 9 lines]
>>
>> Thanks,

Reply to this Message

Erny - 10 Jun 2007 15:30 GMT

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

> Hi,
> If I have a certain cell with text in it that I am hard coding as Female
[quoted text clipped - 4 lines]
>
> Thanks,

Reply to this Message

PCLIVE - 11 Jun 2007 15:08 GMT

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

> Example if certain cell is A1:
> In A2, formula is:
[quoted text clipped - 13 lines]
>>
>> Thanks,

Reply to this Message

Eden397 - 11 Jun 2007 15:22 GMT

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.

> Did you try your formula? You've written it using semi-colons (;) instead
> of commas (,).
[quoted text clipped - 22 lines]
> >>
> >> Thanks,

Reply to this Message

PCLIVE - 11 Jun 2007 15:34 GMT

Remove the quotes from "222".

=IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664!C11="quota","0",IF(Combo_4_000664!C11=222,"1")))

Will C11 ever be Blank? If so, what do you want displayed? If you want it
to be blank, then:
=IF(Combo_4_000664!C11="All","1",IF(Combo_4_000664!C11="quota","0",IF(Combo_4_000664!C11=222,"1","")))

Regards,
Paul

> Thanks, I got it to work and it cleared up my issues. But it lead me to
> one
[quoted text clipped - 37 lines]
>> >>
>> >> Thanks,

Reply to this Message

Eden397 - 11 Jun 2007 15:45 GMT

Thanks, that worked. Are numbers not suppose to have quotations? Also, I
would like to have the cell blank if nothing is entered.

> Remove the quotes from "222".
>
[quoted text clipped - 48 lines]
> >> >>
> >> >> Thanks,

Reply to this Message

PCLIVE - 11 Jun 2007 16:06 GMT

If C11 was formatted as Text, then it would work. However, if it is in the
default format of General, then 222 will be seen as a number and "222" with
quotes will not match since the quotation markes make it a text string. Try
this simpler formula below. The "All" and 222 have been combined into an OR
statement since the result will be the same.

=IF(OR(Combo_4_000664!C11="All",(Combo_4_000664!C11=222)),"1",IF(Combo_4_000664!C11="quota","0",""))

HTH,
Paul

> Thanks, that worked. Are numbers not suppose to have quotations? Also, I
> would like to have the cell blank if nothing is entered.
[quoted text clipped - 55 lines]
>> >> >>
>> >> >> Thanks,

Reply to this Message