Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF Statement equalling multiple words. Please Help
I want to say if cell A1 = "word1" or "word2" or "word3", then "".
Otherwise do this. I know how to make check if it = 1 item, but how do you make it check 3 or four things without using multiple IF statements? Thanks Phil |
#2
|
|||
|
|||
Use and If(or(A1="word1",A1="word2",A1="word3"),then"",els e) That should work for you, Cody "Phillip Vong" wrote: I want to say if cell A1 = "word1" or "word2" or "word3", then "". Otherwise do this. I know how to make check if it = 1 item, but how do you make it check 3 or four things without using multiple IF statements? Thanks Phil |
#3
|
|||
|
|||
=IF(OR(A1="word1",A1="Word2",A1="word3"), "do something","do something
else") if any one stement is true or =IF(AND(A1="word1",A1="Word2",A1="word3"), "do something","do something else") if all statements are true Regards, "Phillip Vong" <phillip_vong*at*yahoo*dot*com wrote in message ... I want to say if cell A1 = "word1" or "word2" or "word3", then "". Otherwise do this. I know how to make check if it = 1 item, but how do you make it check 3 or four things without using multiple IF statements? Thanks Phil |
#4
|
|||
|
|||
Thanks guys!
Phil "Phillip Vong" <phillip_vong*at*yahoo*dot*com wrote in message ... I want to say if cell A1 = "word1" or "word2" or "word3", then "". Otherwise do this. I know how to make check if it = 1 item, but how do you make it check 3 or four things without using multiple IF statements? Thanks Phil |
#5
|
|||
|
|||
On Thu, 17 Mar 2005 13:52:40 -0500, "Phillip Vong"
<phillip_vong*at*yahoo*dot*com wrote: I want to say if cell A1 = "word1" or "word2" or "word3", then "". Otherwise do this. I know how to make check if it = 1 item, but how do you make it check 3 or four things without using multiple IF statements? Thanks Phil A little shorter: =IF(OR(A1={"word1","word2","word3"}),"","do this") --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) |