waxsublime
New Member
- Joined
- Jul 13, 2013
- Messages
- 17
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:
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!
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).
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!