Formula?: IF ("Tyrion" is Here OR There) AND IF ("Crossbow" is over here) = "He will end Joffrey"

[waxsublime]

Okay first just let me say WOW AWESOME FORUM AND SITE!!! I'm really pretty new to Excel formulas, but I'm totally geeking out on it. It's so cool!

Anyway, I'm trying to get a formula to do the following:

[Example]
IF (there is the word "Tyrion" in either A1 OR A3) AND (there is the word "Crossbow" in A2) THEN value is "He will end Joffrey".
(e.g. if "Tyrion" is found in A1 but no "Lannister" in A2, then value is 0).
​

I know this simple formula works (If "Tyrion" is on A1 then value is "Lion"):

=IF(ISNUMBER(FIND("Tyrion",A1)),"Lion",)

But I'm having trouble figuring out how to combine an "OR" with an "AND"... if that makes sense.

Thanks in advance!

 

[Special-K99]

=IF(AND(OR(A1="Tyrion",A3="Tyrion"),A2="Crossbow"),"He will end Joffrey",0)

Though Joffrey will actually get... (Oops! Spoiler alert!)

 

[tusharm]

Searched Excel help for OR or AND?

IF(AND(condition-1,condition-2),true-value,false-value)

and then condition-1 itself can be a function such as OR(condition-3,condition-4)

Okay first just let me say WOW AWESOME FORUM AND SITE!!! I'm really pretty new to Excel formulas, but I'm totally geeking out on it. It's so cool!

Anyway, I'm trying to get a formula to do the following:

[Example]
IF (there is the word "Tyrion" in either A1 OR A3) AND (there is the word "Crossbow" in A2) THEN value is "He will end Joffrey".
(e.g. if "Tyrion" is found in A1 but no "Lannister" in A2, then value is 0).
​

I know this simple formula works (If "Tyrion" is on A1 then value is "Lion"):

=IF(ISNUMBER(FIND("Tyrion",A1)),"Lion",)

But I'm having trouble figuring out how to combine an "OR" with an "AND"... if that makes sense.

Thanks in advance!

 

[waxsublime]

That worked! Thanks so much!!!

And I've Read all the books... no spoilers here though. I Hope Joffrey gets a much more....interesting end. Hehe.