If Statement multiple condition cells

[vanther]

Hi everyone I wonder if excel can do this. I have a conditions want to make like
Like if any of this cells A2,B2,C2,D2 and E2 has a value of "0" (zero) then F2 will put zero otherwise F2 will become 1..

Sorry I am new for this I am learning some basic functions..

THanks in advance....

 

[Canapone]

Hi,

maybe in F2

=--(PRODUCT(A2:E2)>0)

or

=--(COUNTIF(A2:E2,0)<1)

Hope it helps

 

[paddydive]

This will go in F2

=if(and(a2=0,b2=0,c2=0,d2=0,e2=0),0,1) if all A2,B2,C2,D2 and E2 has a value of "0"
=if(or(a2=0,b2=0,c2=0,d2=0,e2=0),0,1) if either one A2,B2,C2,D2 and E2 has a value of "0"

 

[vanther]

thanks for the quick reply... how about the conditions is what if
one of the cells get zero then F2 will be zero.. who to treat for that??

 

[paddydive]

 

[ukmikeb]

Hi

Try :-

enter with Control-Shift-Enter.

hth