IF Statement with both AND and OR Criteria

  • Thread starter Thread starter T
  • Start date Start date
T

T

I'm having difficulty creating an if statement that has both AND/OR
criteria. The following statement covers the OR part, but how do I
include the AND condition?

=IF(OR(A1=TRUE,A2=TRUE),C2,"N/A")

In other words, return the value in C2 if A1=TRUE OR A2=TRUE. In
addition, F2 must = "Include"

Any suggestions would be greatly appreciated. Thanks in advance!

T
 
Back
Top