multiple logical tests

[shternm]

What formula do I use if I want to have multiple logical test values al
IF statement?
For example: If(A1=B1 OR/AND C1, B1,C1)

Thanks a lot

 

[Frank Kabel]

Hi
try
=IF(OR(A1=B1,A1=C1),B1,C1)
or
=IF(AND(A1=B1,A1=C1),B1,C1)

 

[JE McGimpsey]

You use AND or OR:

=IF(AND(A1=B1,A1=C1),B1,C1)

OR

=IF(OR(A1=B1,A1=C1),B1,C1)

 

[Kevin Stecyk]

shternm wrote...

What formula do I use if I want to have multiple logical test values ala
IF statement?
For example: If(A1=B1 OR/AND C1, B1,C1)

=IF(OR(A1=B1,A1=C1), B1, C1)

The key is the OR statement.

Hope that helps.

Best regards,
Kevin