Help with ISERROR

[sadaka]

Hi,

I have a formula for the world gum game predictor, which is throwing #VALUE errors as games have not yet been played, i am not sure how to intergrate the ISERROR within my formula, can you help please?

=IF(N10=J10,3,IF(SIGN(LEFT(N10,FIND("-",N10,1)-1)-RIGHT(N10,LEN(N10)-FIND("-",N10,1)))=SIGN(LEFT(J10,FIND("-",J10,1)-1)-RIGHT(J10,LEN(J10)-FIND("-",J10,1))),1,0))

 

[Andrew Poulsom]

In Excel 2007 and above:

=IFERROR(IF(N10=J10,3,IF(SIGN(LEFT(N10,FIND("-",N10,1)-1)-RIGHT(N10,LEN(N10)-FIND("-",N10,1)))=SIGN(LEFT(J10,FIND("-",J10,1)-1)-RIGHT(J10,LEN(J10)-FIND("-",J10,1))),1,0)),0)