| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mutiple "and"s and "or"s in "IF" statement
sorry if this is a double post. I am trying to author the following generic
statement in excel "IF" reference cell "A17" equals "A" or "B" AND reference cell "A15" equals "1", "2" or "3" then "value" else "different value" thanks in advance |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mutiple "and"s and "or"s in "IF" statement
=IF(AND(OR(A15={"A","B"}),OR(A17={1,2,3})),"Statem ent A","Statement B")
-- Regards, Peo Sjoblom "tcek" wrote in message ... sorry if this is a double post. I am trying to author the following generic statement in excel "IF" reference cell "A17" equals "A" or "B" AND reference cell "A15" equals "1", "2" or "3" then "value" else "different value" thanks in advance |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mutiple "and"s and "or"s in "IF" statement
it is a double post, look at your other one where you have responses
"tcek" wrote: sorry if this is a double post. I am trying to author the following generic statement in excel "IF" reference cell "A17" equals "A" or "B" AND reference cell "A15" equals "1", "2" or "3" then "value" else "different value" thanks in advance |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Mutiple "and"s and "or"s in "IF" statement
You have responses elsewhere.
Pete On Oct 14, 4:48*pm, tcek wrote: sorry if this is a double post. *I am trying to author the following generic statement in excel "IF" reference cell "A17" equals "A" or "B" AND reference cell "A15" equals "1", "2" or "3" then "value" else "different value" thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mutiple "or"s and "and"s in an "IF" statement | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Hybrid Mode
