missing parenthesis - painful!

[stonypaul]

Can anyone help me and point out the missing parenthesis in this beast please? Is there an easy way of checking this type of thing? Thanks

=IF(AND(VLOOKUP(C52,winners!$A$7:$C$526,3,FALSE)="Rollover",VLOOKUP(D52,winners!$A$7:$C$526,3,FALSE)="Rollover"),0,
IF(AND(VLOOKUP(C52,winners!$A$7:$C$526,3,FALSE)<>"Rollover",VLOOKUP(D52,winners!$A$7:$C$526,3,FALSE)<>"Rollover"),
SUMPRODUCT(--(master_list!$A$2:$A$1827=D52)*--(master_list!$B$2:$AX$1827<>"Rollover"))*0.5),
IF(AND(VLOOKUP(C52,winners!$A$7:$C$526,3,FALSE)="Rollover",VLOOKUP(D52,winners!$A$7:$C$526,3,FALSE)<>"Rollover"),
(SUMPRODUCT(--(master_list!$A$2:$A$1827=C52)*--(master_list!$B$2:$AX$1827<>"Rollover"))+SUMPRODUCT(--(master_list!$A$2:$A$1827=D52)*--(master_list!$B$2:$AX$1827<>"Rollover")))*0.5)

 

[kpark91]

=IF(AND(VLOOKUP(C52,winners!$A$7:$C$526,3,FALSE)="Rollover",VLOOKUP(D52,winners!$A$7:$C$526,3,FALSE)="Rollover"),0,
IF(AND(VLOOKUP(C52,winners!$A$7:$C$526,3,FALSE)<>"Rollover",VLOOKUP(D52,winners!$A$7:$C$526,3,FALSE)<>"Rollover"),
SUMPRODUCT(--(master_list!$A$2:$A$1827=D52)*--(master_list!$B$2:$AX$1827<>"Rollover"))*0.5,
IF(AND(VLOOKUP(C52,winners!$A$7:$C$526,3,FALSE)="Rollover",VLOOKUP(D52,winners!$A$7:$C$526,3,FALSE)<>"Rollover"),
(SUMPRODUCT(--(master_list!$A$2:$A$1827=C52)*--(master_list!$B$2:$AX$1827<>Rollover"))+SUMPRODUCT(--(master_list!$A$2:$A$1827=D52)*--(master_list!$B$2:$AX$1827<>"Rollover")))*0.5)

Try??

 

[kpark91]

Or even how about tracing your formula??