Test multiple conditions with IF OR

[nielf]

Hi,

I'm trying to figure out how to test multiple conditions with IF OR.

I have a table like the one below where 7 conditions are checked. Now I want to create a formula that checks all of the 7 conditions and returns TRUE if any of the 7 conditions are TRUE. If all 7 conditions are FALSE then the formula should also return FALSE.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Condition 1[/TD]
[TD]Condition 2[/TD]
[TD]Condition 3[/TD]
[TD]Condition 4[/TD]
[TD]Condition 5[/TD]
[TD]Condition 6[/TD]
[TD]Condition 7[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[TD]FALSE[/TD]
[TD]TRUE[/TD]
[TD]TRUE[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]

Can you help me with that?

 

[oldbrewer]

=if(or(a1=true,b1=true,c1=true,d1=true,e1=true,f1=true,g1=true),true,if(and(a1=false,b1=false,c1=false,d1=false,e1=false,f1=false,g1=false),false,"no"))

 

[nielf]

That worked.

Thank you for the fast reply. It's very much appreciated!

 

[bosco_yip]

Or,

=SUMPRODUCT(--(A1:G1))<>0

Regards

 

[nielf]

Or,

=SUMPRODUCT(--(A1:G1))<>0

Regards

Well that's definitely a shorter formula that the other.

Cheers!