Help with if formula

[volkl77]

Hi All. I am using the following formula but i am not getting the desired result.

=IF(D890=0,IF(D895=0,IF(D900=0,IF(D905=0,IF(D910=0,IF(D915=0,0))))),1)

What i am trying to do is have the IF formula do is give me a 0 value on if each of the cells in the formula is 0. If one of the cells is not equal to 0 I want the formula to give me a 1, which will in turn trigger my conditional formatting. I was using a sum formula but if I have 2 cells with the same value but opposite (one positive and one negative) i was getting a positive formatting result which was wrong. Thanks

 

[njimack]

=if(and(d890=0,d895=0,d900=0,d905=0,d910=0,d915=0),0,1)

 

[kpark91]

Try

=IF(D890=0,IF(D895=0,IF(D900=0,IF(D905=0,IF(D910=0,IF(D915=0,0,1),1),1),1),1),1)