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

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

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

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