Mutiple "or"s and "and"s in an "IF" statement
 

i would like to say in excel format

If cell reference A15 is equal to "A" or "B" and cell reference A17 is equal
to "1", "2" , "3" or "4" then "Statement" or else "A different statement"

thanks in return

Mutiple "or"s and "and"s in an "IF" statement
 

If cell reference A15 is equal to "A" or "B" and cell reference A17 is equal
to "1", "2" , "3" or "4" then "Statement" or else "A different statement"

=IF(AND(OR(A15="A",A15="B"),OR(A17="1",A17="2",A17 ="3",A17="4")),"Statement","A different statement")

Hope this helps.

Note: I put the numbers in quotes, like you had them, but if these are
actual numbers, not text, then remove the quotes.
--
John C


"tcek" wrote:

i would like to say in excel format

If cell reference A15 is equal to "A" or "B" and cell reference A17 is equal
to "1", "2" , "3" or "4" then "Statement" or else "A different statement"

thanks in return

Mutiple "or"s and "and"s in an "IF" statement
 

Try,

=IF(AND(OR(A15="A",A15="B"),OR(A17=1,A17=2,A17=3)) ,"Statement A","Statement
B")

Mike

"tcek" wrote:

i would like to say in excel format

If cell reference A15 is equal to "A" or "B" and cell reference A17 is equal
to "1", "2" , "3" or "4" then "Statement" or else "A different statement"

thanks in return

Mutiple "or"s and "and"s in an "IF" statement
 

Try

=IF(AND(OR(A15={"A","B"}),OR(A17={1,2,3,4})),"Stat ement","Statement 2")

Hope this helps,

Hutch

"tcek" wrote:

i would like to say in excel format

If cell reference A15 is equal to "A" or "B" and cell reference A17 is equal
to "1", "2" , "3" or "4" then "Statement" or else "A different statement"

thanks in return