IF Statement with both AND and OR Criteria

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
 
R

RagDyeR

Try this:

=If(And(F2="Include",Or(A1="True",A2="True")),C2,"NA")

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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
 
Top