Syntax for if (or) two out of three

[Outline]

need help. I want to identify situations where two of the three columns are = 0 within a given row. In the example, below, row 3 needs to have the XX in column F as the TRUE (showing XX, but row 2 would be false, since only 1 of the three columns is zero -this F result would show a BLANK



C D E F (contains my formula)

2 0 5 300 =if(or(sum(c2+d2)=0,"XX",if(sum(C2+e2)=0,"XX",if(sum(c2+e2)=0, "XX", " ")
3 100 0 0


Thanks!

 

[Rick Rothstein]

I want to identify situations where two of the three columns are = 0 within a given row. In the example, below, row 3 needs to have the XX in column F as the TRUE (showing XX, but row 2 would be false, since only 1 of the three columns is zero -this F result would show a BLANK

C D E F (contains my formula)

2 0 5 300 =if(or(sum(c2+d2)=0,"XX",if(sum(C2+e2)=0,"XX",if(sum(c2+e2)=0, "XX", " ")
3 100 0 0

Give this formula a try...

=IF(COUNTIF(A2:C2,0)=2,"XX","")

 

[Outline]

Give this formula a try...

=IF(COUNTIF(A2:C2,0)=2,"XX","")

seems to be working well, thanks!