too many "if"s ?

[excelNewbie22]

hi,
i placed on dozens of cells an if formula, with or,
but it return the wrong result,
i checked several times,
and all conditions for returning "0" - the wanted result, are met,
but it keep returning "1",
at first i thought there's too many "if",
so i delete half to them, just to check,
and still
please tell me where i'm wrong...

=IF(OR(BA2=1,BB2=1,BC2=1,BD2=1,BE2=1,BF2=1,BG2=1,BH2=1,BI2=1,BJ2=1,BK2=1,BL2=1,BM2=1,BN2=1,BO2=1,BP2=1,BQ2=0,BR2=0,BS2>1,BT2>4,BU2=1,BV2=1,BW2=6,BW2=0,BX2=0,AK2+BY2=2,BZ2=1,CA2=1,CB2>0,CC2=1,CD2>1,CE2>2,CF2>3,CG2>4,CH2>4,CI2>3,CJ2>3,CK2>2,CL2>2,CM2>1,CN2>2,CO2=0,CP2=0,CQ2=5,CR2=5,CS2=5,CT2=5,CT2=0,CU2>0,CV2=1,CW2=1,CX2=1,DG2>0,DH2>0,DI2>0,DA2>3,DB2>4,DC2>5,DD2>0,DE2>0,DF2=0,CY2=1,DK2>2,DL2>1,DM2=0,DN2+DO2=0,DQ2+DR2+DS2=0,DT2=0,DU2=1,DV2=1,DW2=1,DX2=1,DY2>4,DZ2>4),1,0)

 

[Fluff]

of which 17 of them will return TRUE

You sure about that?

 

[excelNewbie22]

Fluff - used the evaluate formula, it told me dc2 is also true, which it isn't, any case, tried change it, and nothing changed
is there a formula instead the evaluate one to returned which one returning the 1?

jorismoerings - how did you come up to 17 true?

 

[Fluff]

You sure that's not DG2 rather than DC2?

 

[excelNewbie22]

yooo! fluff!
i was glued to it, and just came to post the exact thing!
(evaluate function don't let copy the results, i had to count the amount of false and sure thing i miscalculate it)
it was dg2 !!
along with bq2

many many thanks to you all!

any way to have a formula for that kind of thing?

 

[jorismoerings]

You sure about that?

Nope, with changing commas to semicolons it messed up the formula references. Still 74 conditions but only 2 (BQ2 and DG2 as already mentioned) are true

 

[Fluff]

any way to have a formula for that kind of thing?

nothing that springs to mind.