syntax error ..Please help

[Dinesh_Excel]

Hi Friends,

Need your help on the below.

While trying to enter the below formula for a range its working fine.

=IF(AND(SUMPRODUCT(0+ISNUMBER(FIND($E$3:$E$8,C3))),1-SUMPRODUCT(0+ISNUMBER(FIND($F$3:$F$6,C3))),1-ISNUMBER(FIND($G$3,D3))),"Scope","Not in Scope")


but when trying to add "1-ISNUMBER(FIND($H$3,D3))), to the above formulae it throwing an error :

=IF(AND(SUMPRODUCT(0+ISNUMBER(FIND($E$3:$E$8,C3))),1-SUMPRODUCT(0+ISNUMBER(FIND($F$3:$F$6,C3))),1-ISNUMBER(FIND($G$3,D3))),1-ISNUMBER(FIND($H$3,D3))),"Scope","Not in Scope")

Attached error screen for your refernce
can somebody help me on this.

Appreciate your help please

Thank you

 

[bosco_yip]

Check this, only need 2 brackets as per highlighted red :

=IF(AND(SUMPRODUCT(0+ISNUMBER(FIND($E$3:$E$8,C3))),1-SUMPRODUCT(0+ISNUMBER(FIND($F$3:$F$6,C3))),1-ISNUMBER(FIND($G$3,D3)),1-ISNUMBER(FIND($H$3,D3))),"Scope","Not in Scope")

Regards
Bosco

 

[Dinesh_Excel]

Thank you Bosco..appreciate your help
Cheers